General Command
What It Does | Key(s) |
Get help | F1 |
Activate menu bar | F10 |
Find an entry | Shift+F5 |
Repeat most recent find operation | Shift+F4 |
Check spelling | F7 |
Workbook File Commands
What It Does | Key(s) |
Create new file | Ctrl+N |
Open file | Ctrl+O |
Print file | Ctrl+P |
Save file | Ctrl+S |
Save copy of file under another name | F12 |
Navigate Worksheets
What It Does | Key(s) |
Move one cell up, down, left, or right | Arrow Keys |
Go to active cell | Ctrl+Backspace |
Move to next unlocked cell on a protected worksheet | Tab |
Move down one screen | Page Down |
Move up one screen | Page Up |
Move one screen to the right | Alt+Page Down |
Move one screen to the left | Alt+Page Up |
Switch to next split pane | F6 |
Switch to previous split pane | Shift+F6 |
Find text or format | Ctrl+F |
Flip to next worksheet page | Ctrl+Page Down |
Flip to previous worksheet page | Ctrl+Page Up |
Go to a specific cell or named range | F5 or Ctrl+G |
Move to edge of current data region | Ctrl+Arrow Key |
Move to beginning of row | Home |
Move to beginning of worksheet | Ctrl+Home |
Move to last cell on worksheet | Ctrl+End |
Navigate in Selected Range
What It Does | Key(s) |
Move from top to bottom of range | Enter |
Move from bottom to top of range | Shift+Enter |
Move from left to right of range | Tab |
Move from right to left of range | Shift+Tab |
Move clockwise to next corner of range | Ctrl+Period |
Switch to selected range to the right | Ctrl+Alt+Right Arrow |
Switch to selected range to the left | Ctrl+Alt+Left Arrow |
Navigate in End Mode
What It Does | Key(s) |
Toggle End mode on or off | End |
Move to next data block in row or column | End+Arrow Key |
Move down and to the right to the last used worksheet cell | End+Home |
Move to rightmost used cell in current row | End+Enter |
Navigate with Scroll Lock
What It Does | Key(s) |
Toggle Scroll Lock on or off | Scroll Lock |
Select cell in upper-left corner of window | Home |
Select cell in lower-right corner of window | End |
Scroll one row up | Up Arrow |
Scroll one row down | Down Arrow |
Scroll one column to left | Left Arrow |
Scroll one column to right | Right Arrow |