Power Query (macOS) keyboard shortcuts 

Power Query (macOS)  

Zeynel -
17 months ago
- Shortcuts
0
Esc

Move focus from step level to query level

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 + G

Go to column

0
⌘ Cmd + E

Add column from examples

0
⌘ Cmd + C

Copy cells/rows/columns

0
⌘ Cmd + A

Select all cells

0
Control + Space

Select column

0
⌥ Opt + Q

Search

0
⌘ Cmd + C

Copy cells/rows/columns

0
⌘ Cmd + V

Paste cells/rows/columns

0
Ctrl + Space

Show suggestions (when available)

0
⌘ Cmd + ↑  Shift + M

Advanced editor

0
⌘ Cmd + ⌥ Opt + T

Enter Data

0
⌘ Cmd + ⌥ Opt + C

Add custom column

0
⌘ Cmd + K

Choose column

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
⌘ Cmd + ⤶ Enter

Save entered data

0
⌘ Cmd +

Expand selected query

0
⌘ Cmd +

Collapse selected query

0
⌥ Opt +

Move focus from query level to step level

0
⌘ Cmd +   

Select multiple consecutive queries

0
⌘ Cmd + ↑  Shift +

Expand all queries

0
⌘ Cmd + ↑  Shift +

Collapse all queries

0
Control + ↑  Shift + M

Toggle tab behavior

0
Control + ⌥ Opt + D

Get Data

0
⌥ Opt + F5

Refresh

0
Fn + ⌘ Cmd + M

Blank query

0
Fn +

Select first column

0
Fn +

Select last column

0
Fn +

Select the cell one page up

0
Fn +

Select the cell one page down

0
Fn +

Select first cell of the row

0
Fn +

Select last cell of the row

0
Source:

Power Query documentation

0
⌘ Cmd + Options + N

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

0
⌘ Cmd + Options + R

Highlight related queries

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

Advertisement

When the focus is on the cell

When the focus is on the column header


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

Program information

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

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

How easy to press shortcuts: 73%

More information >>

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

Shortcut count: 48

Platform detected: macOS

Similar programs



User operations

Add Power Query (macOS) to your list of favorites

Advertisement


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


Only registered users can post links.
 
No comments yet. Ask, or type the first one!

Latest articles