EXCEL SHORTCUTS CHEATSHEET FOR POWER USERS

excelrescue.net/cheatsheet

WORKBOOK FORMAT ACTIONS

New Ctrl + N Underline Ctrl + U Undo Ctrl + Z
Open Ctrl + O Bold Ctrl + B Redo Ctrl + Y
Close Ctrl + W Italic Ctrl + I Find Ctrl + F
Save Ctrl + S Strikethrough Ctrl + 5 Find & replace Ctrl + H
Save as F12 Delete Content Delete Spell check F7
Print Ctrl + P Edit from content
Cell Number Format F2
Insert sheet Alt + Shift + F1 end
General Ctrl + Shift + ~
Insert chart F11 or Alt + F1 Toggle formulas Ctrl + `
Delete sheet Alt + E, L
Time Ctrl + Shift + @
Toggle cell refs F4 (cell edit mode)
Date Ctrl + Shift + # Repeat last action F4 (cell ready mode)
Currency Ctrl + Shift + $ Context menu Shift + F10
CLIPBOARD Number Ctrl + Shift + ! Quick analysis Ctrl + Q
Cut Ctrl + X Percentage Ctrl + Shift + %
Selected
Copy Ctrl + C Scientific Ctrl + Shift + ^
Paste Ctrl + V Borders Insert row / col Ctrl + Shift + +
Paste special Ctrl + Alt + V Delete row / col Ctrl + -
Add Alt + H, B
Hide rows Ctrl + 9
Add outside Ctrl + Shift + 7
Hide columns Ctrl + 0
NAVIGATION Remove Ctrl + Shift + _ Auto fit Alt + H, O, I
Sheet left Ctrl + Page Up Selected Cells Data
Sheet right Ctrl + Page Down Fill color Alt + H, H
Current date Ctrl + ;
Screen up Page Up
Text Align Current time Ctrl + Shift + :
Screen down Page Down
Left Alt + H, A, L Sum selected Ctrl + =
End of data Ctrl + Arrow Key
Right Alt + H, A, R Calculate all Ctrl + Alt + F9
Tabs
Center Alt + H, A, C
Home Alt + H
Open Dialog SELECT
Insert Alt + N
Page layout Alt + P Format Ctrl + 1 All Ctrl + A
Data Alt + A Delete Ctrl + - Row Shift + Space
View Alt + V Insert Ctrl + Shift + + Column Ctrl + Space
Formula Alt + M
Add Extend one cell Shift + Arrow Key
Go To Cell Extend to last Ctrl + Shift +
Comment Shift + F2
used cell End
Choose Ctrl + G Hyperlink Ctrl + K
Active Ctrl + Backspace Next corner of
Table Ctrl + T Ctrl + .
selected
First Ctrl + Home
Line break Alt + Enter
Last Ctrl + End
Fill
Right Ctrl + R
CODE Download a copy at
Down Ctrl + D excelrescue.net/cheatsheet
Open VBA Editor Alt + F11 Multiple with
Ctrl + Enter
Open Macro Box Alt + F8 selected range Excel Rescue is a done-for-you small tasks
service for Microsoft Excel®
© Copyright Excel Rescue Limited