Shortcuts to Navigate and Data Selection Inside Excel Worksheets
- Alt + Arrow Down: Display the Auto Complete list e.g. in cell with
drop downs or auto filter.
- "Alt + Page Down / Alt + Page Up": Move one screen to the right / to the left in a
worksheet.
- Arrow Keys: Move
one cell up, down, left, or right in a worksheet.
- Ctrl + Arrow Keys: Move
to the edge of next data region (cells that contains data)
- Ctrl + End: Move
to the last cell with content on a worksheet.
- Ctrl + f: Display
the Find and Replace dialog box (with Find selected).
- Ctrl + g (or f5): Display
the 'Go To' dialog box.
- Ctrl + h: Display
the Find and Replace dialog box (with Replace selected).
- Ctrl + Home: Move
to the beginning of a worksheet.
- "Ctrl + Left Arrow / Ctrl + Right Arrow": Inside a cell: Move one word to the left / to the
right.
- End: Turn
'End' mode on. In End mode, press arrow keys to move to the next nonblank
cell in the same column or row as the active cell. From here use arrow
keys to move by blocks of data, home to move to last cell, or enter to
move to the last cell to the right.
- Home: Move
to the beginning of a row in a worksheet.
- Home / End: Inside
a cell: Move to the beginning / to the end of a cell entry.
- Page Down / Page Up: Move
one screen down / one screen up in a worksheet.
- Shift + F4: Repeat
last find.
- Tab / Shift + Tab: Move one cell to the right / to the
left in a worksheet.
- Ctrl + . (period): Move clockwise
to the next corner of the selection.
- Ctrl + a (or ctrl + Shift + Spacebar):
Select the entire worksheet or the data-containing area. Pressing ctrl+a a
second time then selects entire worksheet.
- "Ctrl + Alt + Right Arrow / Ctrl
+ Alt + Left Arrow": Move
to the right / to the left between non-adjacent selections (with multiple
ranges selected).
- Ctrl + Backspace: Show active cell
within selection.
- Ctrl + Shift + * (asterisk): Select
the current region around the active cell.
- Ctrl + Shift + Arrow Key: Extend
the selection to the last cell with content in row or column.
- Ctrl + Shift + End: Extend the
selection to the last used cell on the worksheet (lower-right corner).
- Ctrl + Shift + Home: Extend the
selection to the beginning of the worksheet.
- "Ctrl + Shift + Left Arrow / Ctrl
+ Shift + Right Arrow": Select or unselect one word to the left /
to the right.
- Ctrl + Shift + o: Select all cells with comments.
- Ctrl + Shift + Page Up: Select the
current and previous sheet in a workbook.
- Ctrl + Space: Select the entire
column.
- Enter / Shift + Enter: Move active
cell down / up in a selection.
- Esc: Cancel Selection.
- F8: Turn on extension of selection
with arrow keys without having to keep pressing shift.
- Shift + Arrow Keys: Extend the
selection by one cell.
- Shift + Backspace: Select only the
active cell when multiple cells are selected.
- Shift + F8: Add another (adjacent
or non-adjacent) range of cells to the selection. Use arrow keys and shift
+ arrow keys to add to selection.
- Shift + Home: Extend the selection
to the beginning of the row.
- Shift + Home / Shift + End: Select
from the insertion point to the beginning / to the end of the cell.
- "Shift + Left Arrow / Shift +
Right Arrow": Select or unselect one character to the left / to
the right.
- "Shift + Page Down / Shift + Page
Up": Extend the selection down one screen /up one screen.
- Shift + Space: Select the entire
row.
- Tab / Shift + Tab: Move active
cell right / left in a selection.
Use these shortcuts to improve your working and help others!
