Alt X R on Mac: Formulas menu in Excel
To open the Formulas menu with Alt X R in Excel on a Mac, install LightningXL, tap Option, then type X, R. The same keys as Windows, with the same result.
Step by step
Install LightningXL
Download LightningXL, then follow the instructions. Setup takes about two minutes.
Select what to act on
Click a cell, or select the range the command should apply to.
Tap Option, then type X R
Tap ⌥ on its own to show the key tips, then X for LightningXL, R for Formulas. That opens the Formulas menu; the next key tips show the items in it.
What Alt X R does
Alt X R opens the Formulas menu on the LightningXL tab of Excel. Type one more key to pick an item:
- ⌥XRF Flip Sign
- ⌥XRP Wrap Parentheses
- ⌥XRE Error Wrap
- ⌥XRV Convert Formula to Value
- ⌥XRU Unapply Names
- ⌥XRA Anchor Formula
Related shortcuts
The rest of the LightningXL tab in Excel:
- ⌥XLC Fill Color Cycle
- ⌥XBC Border Color Cycle
- ⌥XO Format
- ⌥XC Cells
- ⌥XP Paste
- ⌥XY Symbol
- ⌥XM Comments
- ⌥XT Trace
Every Windows shortcut you know, on your Mac
Alt key tips for the Excel, Word and PowerPoint ribbons, plus 100+ of the most common modeling shortcuts.
7-day free trial · No card required