Home » Our Blog » Excel keyboard shortcuts for quickly moving and selecting in a worksheet

Excel keyboard shortcuts for quickly moving and selecting in a worksheet

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.

KEYS EFFECT
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!

Facebook
Facebook
Twitter
Google+
Google+
DISPLAY_ULTIMATE_PLUS

If you enjoyed this you may also enjoy