Excel Mac 2016 – Frequently used shortcuts

To obtains the complete list of shortcuts visit the official page Keyboard shortcuts in Excel 2016 for Mac

To do this Press
Paste COMMAND + V
or
CONTROL + V
Copy COMMAND + C
or
CONTROL + C
Clear DELETE
Save COMMAND + S
or
CONTROL + S
Undo COMMAND + Z
or
CONTROL + Z
Redo COMMAND + Y
or
CONTROL + Y
or
COMMAND + SHIFT+ Z
Cut COMMAND + X
or
CONTROL + X
Bold COMMAND + B
or
CONTROL + B
Print COMMAND + P
or
CONTROL + P
Open Visual Basic OPTION + F11
Fill Down COMMAND + D
or
CONTROL + D
Fill Right COMMAND + R
or
CONTROL + R
Insert cells CONTROL + SHIFT + =
Delete cells COMMAND + HYPHEN
or
CONTROL + HYPHEN
Calculate all open workbooks COMMAND + =
or
F9
Close window COMMAND + W
or
CONTROL + W
Quit Excel COMMAND + Q
Display the Go To dialog box CONTROL + G
or
F5
Display the Format Cells dialog box COMMAND + 1
or
CONTROL + 1
Display the Replace dialog box CONTROL + H
or
COMMAND + SHIFT + H
Paste Special COMMAND + CONTROL + V
or
CONTROL + OPTION + V
or
COMMAND + OPTION + V
Underline COMMAND + U
Italic COMMAND + I
or
CONTROL + I
New blank workbook COMMAND + N
or
CONTROL + N
New workbook from template COMMAND + SHIFT + P
Display the Save As dialog box COMMAND + SHIFT + S
or
F12
Display the Help window F1
or
COMMAND + /
Select All COMMAND + A
or
COMMAND + SHIFT + SPACEBAR
Add or remove a filter COMMAND + SHIFT + F
or
CONTROL + SHIFT + L
Minimize or maximize the ribbon tabs COMMAND + OPTION + R
Display the Open dialog box COMMAND + O
or
CONTROL + O
Check spelling F7
Open the thesaurus SHIFT + F7
Display the Formula Builder SHIFT + F3
Open the Define Name dialog box COMMAND + F3
Open the Create names dialog box COMMAND + SHIFT + F3
Insert a new sheet * SHIFT + F11
Print COMMAND + P
or
CONTROL + P
Print preview COMMAND + P
or
CONTROL + P
Advertisements