Level 2
Level 1

Navigate Inside Worksheets


14 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
ctrl+page down/up
Move one screen to the right / to the left in a worksheet.
tab/shift+tab
Move one cell to the right / to the left in a worksheet.
ctrl+arrow keys
Move to the edge of next data region (cells that contains data)
home
Move to the beginning of a row in a worksheet.
ctrl+home
Move to the beginning of a worksheet.
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+h
Display the Find and Replace dialog box (with Replace selected).
shift+f4
Repeat last find.
ctrl+g (or f5)
Display the 'Go To' dialog box.
ctrl+arrow left/right
Inside a cell: Move one word to the left / to the right.
home/end
Inside a cell: Move to the beginning / to the end of a cell entry.
alt+arrow down
Display the AutoComplete list e.g. in cell with dropdowns or autofilter.
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.