There are hundreds of Excel tricks and tips that can help you nimbly navigate within a worksheet.
The list of Excel shortcuts is long, but learning the most useful ones can save you quite some time. There are shortcuts for various uses, ranging from formatting options to selecting columns and rows and writing formulae. This article focuses on the most useful navigation tricks.
Moving within the worksheet
Ctrl + page up/down: Switches between workbook tabs
- Ctrl-Arrow Key: Holding down the Ctrl key along with an arrow key (left, right, up, or down) will take you into that direction within the worksheet. The cell this shortcut takes you will be determined by whether the cursor is in a cell that contains data or not:
- If the cell contains data, Ctrl-Arrow Key will take you to the edge of the data region.
- If the cell is empty, Ctrl-Arrow Key will move you in a given direction until Excel encounters a nonblank cell or the edge of worksheet.
- Ctrl-Home: This shortcut always takes you straight back to cell A1.
- Home: Use it to move to the first cell of the row.
- End: It takes you to the next empty cell of the row.
- Ctrl-End: This shortcut takes you to the last used cell within a workbook. However, this doesn’t mean it is the last cell that has data in it. Instead, it is the intersection of the last row and the last column that contain data.
- Page Down: Moves down one screen.
- Page Up: Moves up one screen.
- Alt + Page Down: Moves one screen to the right .
- Alt + Page Up: Moves one screen to the left.
Moving across workbooks
- Ctrl + Tab: Move to the next workbook window.
- Ctrl + Shift + Tab: Move to the previous workbook window.
Moving within a selected range
- Enter: Move down one cell.
- Shift + Enter: Move up one cell.
- Tab: Move right one cell.
- Shift + Tab: Move left one cell.
- CTRL + full stop: Jump to the corners of the selection.
Viewing multiple parts of the worksheet at once
- Alt-WS: This will split the screen into four panes. You can move across the panes with the F6 key.
If you would like to learn more navigation tricks, you can take a look at previous AccountingWEB articles on this topic here: