Coming Soon

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

The full Windows Alt key tips for the Excel, Word and PowerPoint ribbons, and the modeling, auditing and paste keys the LightningXL add-in puts in Excel. Searchable, and 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