Important Excel Shortcuts (Macabacus)
AutoSum
Alt + =
Paste formulas
Alt E S F
Paste formats
Alt E S T
Paste values
Alt E S V
Print Preview
Alt F V
Name Manager...
Alt I N D
Insert row/column
Alt I R / Alt I C
Tools > Options...
Alt T O
Trace precedents/dependents
Alt T U T / Alt T U D
Zoom...
Alt V Z
Format cells...
Ctrl + 1 (or Alt O E)
Go to end of contiguous range
Ctrl + Arrow Keys
Format bold/underline/italic
Ctrl + B / Ctrl + U / Ctrl + I
Copy/cut
Ctrl + C / Ctrl + X
Go home (cell A1)
Ctrl + Home
Ctrl + P
Worksheet next/previous
Ctrl + PgUp / Ctrl + PgDn
Fill right/down
Ctrl + R / Ctrl + D
Border around selection
Ctrl + Shift + 7
Select contiguous range
Ctrl + Shift + Arrow Keys
Enter formula array
Ctrl + Shift + Enter
Borders remove (all)
Ctrl + Shift + _
Workbook toggle
Ctrl + Tab
Paste
Ctrl + V
Workbook close/new/open
Ctrl + W / Ctrl + N / Ctrl + O
Undo/redo/repeat
Ctrl + Z / Ctrl + Y / F4
Go to precedent cells
Ctrl + [
Save as
F12
Edit cell
F2
Anchor cells
F4
Go To...
F5 (or Ctrl + G)
Recalculate all
F9
Select a range
Shift + Arrow Keys
Insert worksheet
Shift + F11 (or Alt I W)
Comment insert/edit
Shift + F2
Select entire row/column
Shift / Ctrl + Spacebar