Tag: Excel Mac

Excel Mac 2016 – Frequently used shortcuts

Posted on by Mauricio Neri
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