Power Query (macOS) keyboard shortcuts

Power Query (macOS)

Zeynel -
4 months ago
- Shortcuts
0
Control + ⌥ Opt + D

Get Data

0
⌘ Cmd + ⌥ Opt + T

Enter Data

0
⌘ Cmd + ⌥ Opt + C

Add custom column

0
⌘ Cmd + K

Choose column

0
⌘ Cmd + G

Go to column

0
⌘ Cmd + E

Add column from examples

0
Fn + ⌘ Cmd + M

Blank query

0
⌘ Cmd + ↑  Shift + M

Advanced editor

0
⌥ Opt + F5

Refresh

0
⌥ Opt + Q

Search

Advertisement

0
⌘ Cmd + C

Copy cells/rows/columns

0
⌘ Cmd + A

Select all cells

0
Control + Space

Select column

When the focus is on the column header

0
⌥ Opt +

Expand table

0
⌘ Cmd +

Change column type menu

0
⌘ Cmd +

Move focus to column header on the left

0
⌘ Cmd +

Move focus to column header on the right

0
Fn +

Select first column

0
Fn +

Select last column

When the focus is on the cell

0
Fn +

Select first cell of the row

0
Fn +

Select last cell of the row

0
Fn + ⌥ Opt +

Select first cell of the column

0
Fn + ⌥ Opt +

Select last cell of the column

0
Fn + ⌘ Cmd +

Select first cell of the first row

0
Fn + ⌘ Cmd +

Select last cell of the last row

0
Fn +

Select the cell one page up

0
Fn +

Select the cell one page down

0
⌘ Cmd + C

Copy cells/rows/columns

0
⌘ Cmd + V

Paste cells/rows/columns

0
⌘ Cmd + ⤶ Enter

Save entered data

0
Ctrl + Space

Show suggestions (when available)

0
Control + ↑  Shift + M

Toggle tab behavior

0
⌘ Cmd +

Expand selected query

0
⌘ Cmd +

Collapse selected query

0
⌥ Opt +

Move focus from query level to step level

0
Esc

Move focus from step level to query level

0
⌘ Cmd + ↑  Shift +

Expand all queries

0
⌘ Cmd + ↑  Shift +

Collapse all queries

0
⌘ Cmd + Options + N

Insert new step using 'plus' button (after selected step)

0
⌘ Cmd + Options + R

Highlight related queries

0
⌘ Cmd + A

Select all queries

0
⌘ Cmd + C

Copy queries

0
⌘ Cmd + V

Paste queries

0
⌘ Cmd + A

Select all queries

0
⌘ Cmd + C

Copy queries

0
⌘ Cmd + V

Paste queries

0
⌘ Cmd +   

Select multiple consecutive queries

0
Source:

Power Query documentation


Share this page on:
Is this page helpful?
0 0

Program information

Program name: Power Query (macOS) Power Query (macOS) (Productivity)

Power Query is an ETL (Extract, Transform, Load) tool developed by Microsoft for data extraction, loading, and transformation, and is used to retrieve data from sources. It was included in Microsoft Excel 2010 and 2013. In Excel 2016, the name of the feature was changed to "Get & Transform" but later changed to Power Query again.

Web page: support.microsoft.com/en-us/of...

How easy to press shortcuts: 73%

More information >>

Updated: Updated program information. (3 updates.) 12/21/2023 10:45:24 PM New program added.
12/21/2023 10:46:19 PM Added some shortcuts.
12/21/2023 10:47:44 PM Updated program information.

Shortcut count: 48

Platform detected: macOS

Similar programs



User operations

Add Power Query (macOS) to favorites

Add to favorites

Advertisement


What is your favorite Power Query (macOS) hotkey? Do you have any useful tips for it? Let other users know below.


 
No comments yet. Ask, or type the first one!