Excel Hotkeys

HotkeyNavigation
HomeTo leftmost cell in row
CTRL HomeTo cell A1
CTRL End To last used cell
Page up/downOne screen up/down
Alt Page up/downOne scree right/left
ArrowMove one cell
CTRL ArrowMove to end of table
EnterMove down one cell
Shift Enter Move up one cell
TabMove right one cell
Shift tabMove left one cell
Alt EnterNew line in same cell
Shift F11Insert new sheet
CTRL ASelect current region arround active cell
Shift ArrowExtend selection by one cell
Shift CTRL ArrowExtend selection to last nonblank cell
Shift HomeExtend selection to start of row
Shift CTRL HomeExtend selection to top left
Shift CTRL EndExtend selection to last cell used
CTRL SpacebarSelect entire column
Shift Spacebar Select entire row
CTRL ASelect entire sheet
Shift Page Dn / UpExtend the selection one screen
Alt =Insert sum formula
CTRL Shift ~Regular number format
CTRL Shift !Decimal number format
CTRL Shift @Time format
CTRL Shift #Date format
CTRL Shift $Dollar format
CTRL Shift %Percentage format
CTRL Shift ^Scientific Notation
CTRL Shift &Outline
CTRL Shift F or CTRL 1Format cells
CTRL B Bold
CTRL I Italic
CTRL UUnderline
CTRL 5 Strike through
CTRL KInsert hyperlink
F1Help menu
F2Edit cell
F3Paste name into formula
F4Absolute reference
F5Go to
F6 Next pane
F7Spell check
F8Select anchor
F9Calculate
F10 Access keys
F11Create chart sheet
F12 Save as
Alt F11 VBA window
Shift F5Find and replace
Shift F2Insert comment
Shift F3Function wizard
CTRL F4Closes file
CTRL F5Restore window size
Alt F4Close program
CTRL ASelect current region, select all
CTRL CCopy
CTRL XCut
CTRL VPaste
CTRL -Delete
CTRL RCopy right for selected cells
CTRL DCopy down for selected cells
CTRL FFind
CTRL GGo to
CTRL HReplace
CTRL YRedo
CTRL Z Undo
CTRL NNew workbook
CTRL O Open
CTRL WClose window
CTRL PPrint
CTRL SSave workbook
CTRL ~Show formula's
CTRL 'Copy above formula
CTRL 9Hide rows
CTRL Shift 9Unhide rows
CTRL 0Hide columns
CTRL Shift 0Unhide columns