Coming Soon

Alt A R on Mac: Refresh All menu in Excel

To open the Refresh All menu with Alt A R in Excel on a Mac, install LightningXL, tap Option, then type A, R. The same keys as Windows, with the same result.

⌥Option
AData
RRefresh All

Step by step

  1. Install LightningXL

    Download LightningXL, then follow the instructions. Setup takes about two minutes.

  2. Select what to act on

    Click a cell, or select the range the command should apply to.

  3. Tap Option, then type A R

    Tap ⌥ on its own to show the key tips, then A for Data, R for Refresh All. That opens the Refresh All menu; the next key tips show the items in it.

What Alt A R does

Alt A R opens the Refresh All menu on the Data tab of Excel. Type one more key to pick an item:

Related shortcuts

The rest of the Data tab in Excel:

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.

Coming Soon

7-day free trial · No card required