Excel shortcuts

15 Excel Keyboard Shortcuts for Navigating & manipulating rows and columns

If you work with large amounts of data in Microsoft Excel, you know how important it is to be able to move quickly and efficiently between cells, rows, and columns. Keyboard shortcuts can save you a lot of time and effort, and once you get used to using them, they become second nature. Here are 15 essential keyboard shortcuts for working with rows and columns in Excel.

1. Select a Single Cell

To select a single cell, just click on it with your mouse. You can also use the arrow keys on your keyboard to move to the cell you want to select, and then press the Enter key.

2. Select a Range of Cells

To select a range of cells, click on the first cell in the range, and then hold down the Shift key while you click on the last cell in the range. You can also use your mouse to click and drag over the cells you want to select.

3. Select an Entire Row

To select an entire row, click on the row number on the left side of the screen. You can also use the keyboard shortcut Shift+Spacebar to select an entire row.

4. Select an Entire Column

To select an entire column, click on the column letter at the top of the screen. You can also use the keyboard shortcut Ctrl+Spacebar to select an entire column.

5. Insert a New Row

To insert a new row, right-click on the row number of the row where you want the new row to be inserted, and then select Insert from the menu that appears. You can also use the keyboard shortcut Ctrl+Shift+ plus sign (+) to insert a new row.

6. Insert a New Column

To insert a new column, right-click on the column letter of the column where you want the new column to be inserted, and then select Insert from the menu that appears. You can also use the keyboard shortcut Ctrl+Shift+ plus sign (+) to insert a new column.

7. Delete a Row

To delete a row, right-click on the row number of the row you want to delete, and then select Delete from the menu that appears. You can also use the keyboard shortcut Ctrl+minus sign (-) to delete a row.

8. Delete a Column

To delete a column, right-click on the column letter of the column you want to delete, and then select Delete from the menu that appears. You can also use the keyboard shortcut Ctrl+minus sign (-) to delete a column.

9. Hide a Row

To hide a row, right-click on the row number of the row you want to hide, and then select Hide from the menu that appears. You can also use the keyboard shortcut Ctrl+9 to hide a row.

10. Hide a Column

To hide a column, right-click on the column letter of the column you want to hide, and then select Hide from the menu that appears. You can also use the keyboard shortcut Ctrl+0 (zero) to hide a column.

11. Unhide a Row

To unhide a row, right-click on the row number of the row above the hidden row, and then select Unhide from the menu that appears. You can also use the keyboard shortcut Ctrl+Shift+9 to unhide a row.

12. Unhide a Column

To unhide a column, right-click on the column letter of the column to the left of the hidden column, and then select Unhide from the menu that appears. You can also use the keyboard shortcut Ctrl+Shift+0 (zero) to unhide a column.

13. Move a Row

To move a row, click on the row number of the row you want to move, and then use your mouse to drag the row to the new location. You can also use the keyboard shortcut Alt+Shift+arrow keys to move a row.

14. Move a Column

To move a column, click on the column letter of the column you want to move, and then use your mouse to drag the column to the new location. You can also use the keyboard shortcut Alt+Shift+arrow keys to move a column.

15. Sort Data in a Row or Column

To sort data in a row or column, click on the cell at the top or left of the data you want to sort, and then click on the Sort & Filter button in the Data Tools group on the Home tab. You can also use the keyboard shortcut Alt+Shift+A to sort data in a row or column.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.