Every Alt key shortcut for Excel, Word and PowerPoint on the Mac

The same sequences you already know from Windows.

⌥ Option ⌃ Control ⇧ Shift

Numbers

11 commands
General Number Cycle⌃⇧1
Currency Cycle⌃⇧4
Percent Cycle⌃⇧5
Multiple Cycle⌃⇧8
Date Cycle⌃⇧2
Binary Cycle⌃⇧Y
Ratio Cycle⌥⇧;
Increase Decimals⌃,
Decrease Decimals⌃.
Shift Decimal Left⌥⇧,
Shift Decimal Right⌥⇧.

Colors

8 commands
Blue-Black Toggle⌃;
Font Color Cycle⌃'
Fill Color Cycle⌃⇧K
Border Color Cycle⌃⌥⇧'
AutoColor Cycle⌃⌥.
AutoColor Selection⌃⌥A
AutoColor Sheet⌃⌥S
AutoColor Workbook⌃⌥Q

Alignment

5 commands
Horizontal Cycle⌃⇧H
Vertical Cycle⌃⌥⇧V
Left Indent Cycle⌃⇧I
Right Indent Cycle⌃⌥⇧I
Wrap Text⌃⇧W

Borders

7 commands
Top Border⌃⌥⇧↑
Bottom Border⌃⌥⇧↓
Left Border⌃⌥⇧←
Right Border⌃⌥⇧→
Outside Borders⌃⇧7
Inside Borders⌃⌥⇧7
No Border⌃⌥⇧8

Fonts

6 commands
Font Style Cycle⌃⌥O
Font Size Cycle⌥⇧G
Increase Font⌃⇧F
Decrease Font⌃⇧G
Underline Cycle⌃⇧U
Case Cycle⌥⇧C

Styles

1 commands
Custom Style Cycle⌃⌥1

Formulas

9 commands
Flip Sign⌃⇧N
Wrap Parentheses⌃⌥9
Sum Bar⌃⇧M
Pro Copy Right⌃⇧R
Pro Copy Down⌃⇧D
Convert Formula to Value⌃F2
Error Wrap⌃⌥⇧E
Unapply Names⌃⌥⇧U
Anchor Cycle⌃⌥⇧A

Paste

6 commands
Paste Insert⌃⌥I
Paste Number Formats⌃⌥F
Paste Links⌃⌥L
Paste Exact Formulas⌃⌥E
Paste Duplicate⌃⌥D
Paste Transpose⌃⌥T

Auditing

6 commands
Trace In⌃⇧[
Trace Out⌃⇧]
Last Audited Cell⌃⇧\
Show All Precedents⌃⌥[
Show All Dependents⌃⌥]
Clear Arrows⌃⌥\

Navigation & View

18 commands
Uniform Range⌃Q
Zoom In⌃⌥=
Zoom Out⌃⌥-
Toggle Gridlines⌃⌥G
Toggle Page Breaks⌃⌥B
Maximize Workspace⌃⌥⇧W
First Sheet⌃⌥Home
Last Sheet⌃⌥End
Next Sheet⌃⌥PgDn
Previous Sheet⌃⌥PgUp
Move Sheet Left⌃⌥⇧N
Move Sheet Right⌃⌥⇧M
Go to Minimum⌃⌥⇧,
Go to Maximum⌃⌥⇧.
Jump Right⌃⌥→
Jump Left⌃⌥←
Jump Down⌃⌥↓
Jump Up⌃⌥↑

Rows & Columns

19 commands
Row Height Cycle⌥⇧PgUp
Column Width Cycle⌃⌥⇧PgUp
AutoFit Rows⌥⇧PgDn
AutoFit Columns⌃⌥⇧PgDn
Insert Rows⌥⇧Ins
Insert Columns⌃⌥⇧Ins
Delete Rows⌥⇧Del
Delete Columns⌃⌥⇧Del
Hide Rows⌥⇧Home
Hide Columns⌃⌥⇧Home
Unhide Rows⌥⇧End
Unhide Columns⌃⌥⇧End
Expand Rows⌥⇧=
Expand Columns⌃⌥⇧=
Collapse Rows⌥⇧-
Collapse Columns⌃⌥⇧-
Proper Hide⌃⌥H
Copy Row Heights and Column Widths⌃⌥J
Paste Row Heights and Column Widths⌃⌥K

Comments

2 commands
Comment Formula⌃⌥'
Delete Comments⌃⌥⇧D

Export

3 commands
Quick Export to PowerPoint⌃⌥⇧X
Quick Export to Word⌃⌥⇧Y
Refresh the export selected in PowerPoint from the cells or chart it came from⌃⌥⇧R

File

3 commands
Quick Save⌃⇧S
Quick Save As⌥F12
Quick Save Up⇧F12