www.wallstreetprep.com
Excel 2013 Reference Sheet
Formatting shortcuts
Bold CTRL + B
Italic CTRL + I
Underline CTRL + U
Format Box CTRL + 1
Copy CTRL + C
Paste CTRL + V
Paste Only Formats ALT + E + S + T
Paste Only Formulas ALT + E + S + F
Paste Only Values ALT + E + S + V
Cut CTRL + X
Repeat CTRL + Y
Undo CTRL + Z
Delete cell contents Delete
Delete all cell aributes ALT + H + E + A
Delete cell comment ALT + H + E + M
Outline border SHIFT + CTRL + &
Remove border SHIFT + CTRL + _
Insert a comment SHIFT + F2
Workbook navigation shortcuts
Toggle Excel workbooks CTRL + TAB
Split Screen ALT + W + S (F6 to jump from pane to pane)
Freeze pane ALT + W + F + F
New workbook CTRL + N
Print CTRL + P
Open workbook CTRL + O (CTRL + F12)
Save workbook CTRL + S
Activate menu bar ALT or F10
Min / Restore Ribbon CTRL + F1
Auditing shortcuts
Trace immediate precedents ALT + M + P
Trace immediate dependents ALT + M + D
Remove tracing arrows ALT + M + A + A
Evaluate formula ALT + M + V
Track changes ALT + R + G
Zoom to selection ALT + W + G
Go to precedent cells CTRL + [
Go to dependent cells CTRL + ]
Go back to original cell F5 + Enter
“Go to” F5
Tab navigation
Move/ Copy a tab ALT + H + O + M
Change tab name ALT + H + O + R
Moving to le/right tabs CTRL + Pg Up/Down
New tab SHIFT + F11
Insert worksheet ALT + I + W
Row/column shortcuts
Select column CTRL + Space
Select row Shi + Space
Delete row(s) / column(s) CTRL + ‘minus sign’
Add row(s) / column(s) CTRL + SHIFT + ‘plus sign’
Group / ungroup rows and columns SHIFT + ALT + le / right arrow key
Fit column width ALT + H + O + I
Data editing shortcuts
Select All CTRL + A
Fill Down CTRL + D
