Power Query (macOS) keyboard shortcuts 

Power Query (macOS)  

Zeynel -
17 months ago
- Shortcuts
0
Esc

Move focus from step level to query level

0
Ctrl + Space

Show suggestions (when available)

0
⌘ Cmd + C

Copy queries

0
or ⌘ Cmd + C
0
⌘ Cmd + C

Copy cells/rows/columns

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 queries

0
or ⌘ Cmd + A
0
⌘ Cmd + A

Select all cells

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 cell of the row

0
Fn +

Select last column

0
Fn +

Select the cell one page down

0
Fn +

Select the cell one page up

0
Control + Space

Select column

0
⌘ Cmd +   

Select multiple consecutive queries

0
Control + ⌥ Opt + D

Get Data

0
⌥ Opt + Q

Search

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
⌥ Opt + F5

Refresh

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
⌘ Cmd + Options + N

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

When the focus is on the cell

When the focus is on the column header

0
Fn + ⌘ Cmd + M

Blank query


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