MS-Excel / General Formatting

General Command

What It DoesKey(s)
Get helpF1
Activate menu barF10
Find an entryShift+F5
Repeat most recent find operationShift+F4
Check spellingF7

Workbook File Commands

What It DoesKey(s)
Create new fileCtrl+N
Open fileCtrl+O
Print fileCtrl+P
Save fileCtrl+S
Save copy of file under another nameF12

Navigate Worksheets

What It DoesKey(s)
Move one cell up, down, left, or rightArrow Keys
Go to active cellCtrl+Backspace
Move to next unlocked cell on a protected worksheetTab
Move down one screenPage Down
Move up one screenPage Up
Move one screen to the rightAlt+Page Down
Move one screen to the leftAlt+Page Up
Switch to next split paneF6
Switch to previous split paneShift+F6
Find text or formatCtrl+F
Flip to next worksheet pageCtrl+Page Down
Flip to previous worksheet pageCtrl+Page Up
Go to a specific cell or named rangeF5 or Ctrl+G
Move to edge of current data regionCtrl+Arrow Key
Move to beginning of rowHome
Move to beginning of worksheetCtrl+Home
Move to last cell on worksheetCtrl+End

Navigate in Selected Range

What It DoesKey(s)
Move from top to bottom of rangeEnter
Move from bottom to top of rangeShift+Enter
Move from left to right of rangeTab
Move from right to left of rangeShift+Tab
Move clockwise to next corner of rangeCtrl+Period
Switch to selected range to the rightCtrl+Alt+Right Arrow
Switch to selected range to the leftCtrl+Alt+Left Arrow

Navigate in End Mode

What It DoesKey(s)
Toggle End mode on or offEnd
Move to next data block in row or columnEnd+Arrow Key
Move down and to the right to the last used worksheet cellEnd+Home
Move to rightmost used cell in current rowEnd+Enter

Navigate with Scroll Lock

What It DoesKey(s)
Toggle Scroll Lock on or offScroll Lock
Select cell in upper-left corner of windowHome
Select cell in lower-right corner of windowEnd
Scroll one row upUp Arrow
Scroll one row downDown Arrow
Scroll one column to leftLeft Arrow
Scroll one column to rightRight Arrow
[Contents] [Next]

In this tutorial:

  1. Excel Shortcut Keys
  2. General Command
  3. Data Entry
  4. Extend Selection