Important Excel Shortcuts IMPORTANT EXCEL SHORTCUTS COMMAND
KEYSTROKE
COMMAND
KEYSTROKE
Anchor cells
F4 (in cell edit mode only)
Paste
Ctrl + V
AutoSum
Alt + =
Paste formats
Alt E S T
Border around selection
Ctrl + Shift + 7
Paste formulas
Alt E S F
Borders remove (all)
Ctrl + Shift + _
Paste values
Alt E S V
Comment insert/edit
Shift + F2
Ctrl + P
Copy/cut
Ctrl + C / Ctrl + X
Print preview
Alt F V
Edit cell
F2
Recalculate all
F9
Enter formula array
Ctrl + Shift + Enter
Save as
F12
Fill right/down
Ctrl + R / Ctrl + D
Select a range
Shift + Arrow Keys
Format bold/underline/italic
Ctrl + B / Ctrl + U / Ctrl + I
Select contiguous range
Ctrl + Shift + Arrow Keys
Format cells…
Ctrl + 1 (or Alt O E)
Select entire row/column
Shift / Ctrl + Spacebar
Go To…
F5 (or Ctrl + G)
Tools > Options…
Alt T O
Go home (cell A1)
Ctrl + Home
Trace precedents/dependents
Alt T U T / Alt T U D
Go to end of contiguous range
Ctrl + Arrow Keys
Undo/redo/repeat
Ctrl + Z / Ctrl + Y / F4
Go to precedent cells
Ctrl + [
Workbook close/new/open
Ctrl + W / Ctrl + N / Ctrl + O
Insert row/column
Alt I R / Alt I C
Workbook toggle
Ctrl + Tab
Insert worksheet
Shift + F11 (or Alt I W)
Worksheet next/previous
Ctrl + PgUp / Ctrl + PgDn
Name Manager…
Alt I N D
Zoom…
Alt V Z
CoachingAssembly. All rights reserved. Any unauthorised copying, duplication, reproduction, re-selling, distribution or other commercial use will constitute an infringement of copyright
1