Power Query (Windows) keyboard shortcuts

Power Query (Windows)

Zeynel -
4 months ago
- Shortcuts
0
Ctrl + Alt + D

Get Data

0
Ctrl + Alt + T

Enter Data

0
Ctrl + Alt + C

Add custom column

0
Ctrl + K

Choose column

0
Ctrl + G

Go to column

0
Ctrl + E

Add column from examples

0
Ctrl + M

Blank query

0
Ctrl + ↑  Shift + M

Advanced editor

0
Alt + F5

Refresh

0
Alt + Q

Search

Advertisement

0
Ctrl + C

Copy cells/rows/columns

0
Ctrl + A

Select all cells

0
Ctrl + Space

Select column

When the focus is on the column header

0
Alt +

Expand table

0
Ctrl +

Change column type menu

0
Ctrl +

Move focus to column header on the left

0
Ctrl +

Move focus to column header on the right

0
Home

Select first column

0
End

Select last column

When the focus is on the cell

0
Home

Select first cell of the row

0
End

Select last cell of the row

0
Alt + Home

Select first cell of the column

0
Alt + End

Select last cell of the column

0
Ctrl + Home

Select first cell of the first row

0
Ctrl + End

Select last cell of the last row

0
Page Up

Select the cell one page up

0
Page Down

Select the cell one page down

0
Ctrl + C

Copy cells/rows/columns

0
Ctrl + V

Paste cells/rows/columns

0
Ctrl + ⤶ Enter

Save entered data

0
Ctrl + Space

Show suggestions (when available)

0
Ctrl + M

Toggle tab behavior

0
Ctrl +

Expand selected query

0
Ctrl +

Collapse selected query

0
Alt +

Move focus from query level to step level

0
Esc

Move focus from step level to query level

0
Ctrl + ↑  Shift +

Expand all queries

0
Ctrl + ↑  Shift +

Collapse all queries

0
Ctrl + Alt + N

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

0
Ctrl + Alt + R

Highlight related queries

0
Ctrl + A

Select all queries

0
Ctrl + C

Copy queries

0
Ctrl + V

Paste queries

0
Ctrl + A

Select all queries

0
Ctrl + C

Copy queries

0
Ctrl + V

Paste queries

0
Ctrl +   

Select multiple consecutive queries


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

Program information

Program name: Power Query (Windows) Power Query (Windows) (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: powerquery.microsoft.com/en-us

How easy to press shortcuts: 84%

More information >>

Updated: Updated program information. (2 updates.) 12/21/2023 2:05:45 PM New program added.
12/21/2023 2:07:15 PM Updated program information.

Shortcut count: 47

Platform detected: Windows or Linux

Similar programs



User operations

Add Power Query (Windows) to favorites

Add to favorites

Advertisement


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


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