Increase your data entry speed using keyboard shortcuts to quickly move and select in an Excel workbook.
It doesn’t matter if it’s an Excel Stage 1, 2 or 3 course I’m running, there is always somebody who has never seen these shortcuts. I’d love a dollar for every time I have heard “that’s fantastic” when I have shared them with a class.
They love learning them as they save so much time! I hope you enjoy using them too.
In this post I’ll explain the shortcut keys to quickly move around your data and then explain how you can include the SHIFT key to move and select at the same time.
Keyboard shortcuts for quickly moving the cell selector
Try these shortcut key combinations to quickly move the cell selector around your worksheet.
|UP, DOWN, LEFT, RIGHT ARROWS||Moves cell locator one cell in the direction of the arrow pressed|
|CTRL + ARROW KEY||Moves cell locator to the next cell containing data. If cells are empty the cell locator will move to the very edge of the worksheet. For example, CTRL + RIGHT ARROW would advance the cell locator to very last column of the worksheet|
|HOME||Moves cell locators to column A in the selected row|
|CTRL + HOME||Moves cell locator to cell A1|
|CTRL + END||Moves cell locator to the last active cell in the worksheet|
|PAGE UP||Moves cell locator one screen up|
|PAGE DOWN||Moves cell locator one screen down|
|ALT + PAGE UP||Moves cell locator one screen left|
|ALT + PAGE DOWN||Moves cell locator one screen right|
|F5||Opens the Go To dialog box. Type in the specified cell address and then click OK. The cell selector will move to that cell|
Keyboard shortcuts for moving and selecting at the same time
Press SHIFT and a key combination from above to move and select at the same time, e.g. CTRL + SHIFT + DOWN ARROW will select from the current cell to the bottom of a list.
If you found this post helpful please ‘Like’ us!
If you enjoyed this you may also enjoy
- Excel Control key shortcut tips to save you time
- How to calculate GST at 15% using Excel formulas
- 5 Paste tips in Excel that will save you HEAPS of time