Coming Soon

Alt A P N P on Mac: Get Data (Power Query) in Excel

To run Get Data (Power Query) with Alt A P N P in Excel on a Mac, install LightningXL, tap Option, then type A, P, N, P. The same keys as Windows, with the same result.

⌥Option
AData
P
NGet Data
PGet Data (Power Query)

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 P N P

    Tap ⌥ on its own to show the key tips, then A for Data, P N for Get Data, P for Get Data (Power Query).

What Alt A P N P does

Get Data (Power Query) sits under Data › Get Data on the Excel ribbon. On Windows, Alt A P N P runs it from the keyboard. Excel for Mac has the same ribbon but no Alt key, so without LightningXL you click through Data › Get Data › Get Data (Power Query) instead.

Related shortcuts

The rest of the Get Data menu 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