Moving and selecting practice exercises
Stop scrolling and dragging. Jump to the end of your data, go back to A1 and select whole tables, rows and columns from the keyboard, the way fast Excel users do.
How to move and select with the keyboard
Moving and selecting from the keyboard is one of the quickest ways to speed up in Excel, and it takes only a handful of shortcuts. Ctrl+Arrow jumps to the edge of a block of data, and adding Shift selects everything on the way. Ctrl+Home takes you back to A1, and Ctrl+End to the last cell you've used. Shift+Space selects the row you're in, Ctrl+Space the column, and Ctrl+A the table or the whole sheet.
Say a list of invoices fills A1:C500. From A1, Ctrl+Down lands on A500 in one jump. Ctrl+Shift+Right and then Ctrl+Shift+Down select the whole table, A1:C500, however long it grows. Ctrl+Home brings you back to A1.
A blank cell stops Ctrl+Arrow, so if a jump ends halfway down, there is a gap in your data. Ctrl+End goes to the last cell Excel counts as used, which can sit below your data if formatting is left behind. On a Mac, use Cmd instead of Ctrl for the arrow keys. The exercises below cover jumping to the end of a list, selecting a whole table, and selecting rows, columns and the whole sheet.
- 1Jump to the end of your dataMove around a list of invoices with the keyboard instead of scrolling.
- 2Select a whole tableSelect a table of any size with two shortcuts.
- 3Select rows, columns and everythingSelect a whole row, a whole column and the whole sheet from the keyboard.
Read the guide
Questions
How do I select a whole column in Excel with the keyboard?
Click any cell in the column and press Ctrl+Space. For a whole row, press Shift+Space. To add the next columns, hold Shift and press the right arrow after Ctrl+Space. If you only want the filled part of the column, press Ctrl+Shift+Down from the first cell instead, and Excel stops at the end of the data.
What is the difference between Ctrl+Down and Ctrl+End?
Ctrl+Down jumps down the column you are in, to the end of the block of data. If you start in a blank cell, it jumps to the next filled cell. Ctrl+End goes to the bottom-right corner of the used area of the whole sheet, whatever column you are in. Use Ctrl+Down to move around a table and Ctrl+End to see how far the sheet reaches.
How do I select a large range without dragging?
Click the first cell, scroll to the last one, hold Shift and click it. Or type the range, for example A1:C500, in the Name Box left of the formula bar and press Enter. If the data has no gaps, Ctrl+Shift+Right and Ctrl+Shift+Down from the first cell select the whole table without any scrolling.