Power Query (macOS) keyboard shortcuts 

Power Query (macOS)  

Zeynel -
17 months ago
- Shortcuts
0
Control + Space

Select column

0
⌥ Opt + Q

Search

0
⌥ Opt + F5

Refresh

0
Esc

Move focus from step level to query level

0
Ctrl + Space

Show suggestions (when available)

0
⌘ Cmd + C

Copy cells/rows/columns

0
or ⌘ Cmd + C
0
⌘ Cmd + C

Copy queries

0
or ⌘ Cmd + C
0
⌘ Cmd + V

Paste cells/rows/columns

0
⌘ Cmd + V

Paste queries

0
or ⌘ Cmd + V
0
⌘ Cmd + A

Select all cells

0
⌘ Cmd + A

Select all queries

0
or ⌘ Cmd + A
0
⌘ Cmd + K

Choose column

0
⌘ Cmd + E

Add column from examples

0
⌘ Cmd + G

Go to column

0
⌘ Cmd + ⤶ Enter

Save entered data

0
⌘ Cmd +

Move focus to column header on the left

0
⌘ Cmd +

Collapse selected query

0
⌘ Cmd +

Change column type menu

0
⌘ Cmd +

Move focus to column header on the right

0
⌘ Cmd +

Expand selected query

0
⌘ Cmd + ↑  Shift + M

Advanced editor

0
⌘ Cmd + ⌥ Opt + C

Add custom column

0
⌘ Cmd + ⌥ Opt + T

Enter Data

0
Fn +

Select first column

0
Fn +

Select first cell of the row

0
⌥ Opt +

Expand table

0
⌥ Opt +

Move focus from query level to step level

0
⌘ Cmd + ↑  Shift +

Expand all queries

0
⌘ Cmd + ↑  Shift +

Collapse all queries

0
Fn +

Select last column

0
Fn +

Select last cell of the row

0
Fn +

Select the cell one page down

0
Fn +

Select the cell one page up

0
⌘ Cmd +   

Select multiple consecutive queries

0
Control + ⌥ Opt + D

Get Data

0
Control + ↑  Shift + M

Toggle tab behavior

0
Source:

Power Query documentation

0
Fn + ⌘ Cmd +

Select first cell of the first row

0
Fn + ⌘ Cmd +

Select last cell of the last row

0
Fn + ⌥ Opt +

Select first cell of the column

0
Fn + ⌥ Opt +

Select last cell of the column

0
⌘ Cmd + Options + R

Highlight related queries

Advertisement

0
Fn + ⌘ Cmd + M

Blank query

When the focus is on the column header

When the focus is on the cell

0
⌘ Cmd + Options + N

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


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