Bottom line: Learn a few shortcuts to quickly open the Power Query Editor in Excel.
Skill level: Intermediate
The Window to a Whole New World in Excel
Power Query (PQ) is an amazing tool that allows us to automate data transformations in Excel. Once you start using it, you'll want to get to the PQ Editor window quickly.
Power Query is currently a separate window that opens on top of Excel. There are quite a few ways to open this window. Some require more clicks than others. In this post we'll look at a few shortcuts, including keyboard shortcuts, to make this process faster.
The Get Data Menu
One quick way to open the PQ Editor is by clicking the “Launch Power Query Editor” button in the Get Data drop-down menu on the Data tab of the ribbon.
Getting to this button is going to require multiple clicks, especially if you're not on the Data tab. However, there a few ways to get there faster.
The Quick Access Toolbar
The “Launch Power Query Editor” button can be added to the Quick Access Toolbar (QAT). You can right-click the item in the Get Data menu, then select Add to Quick Access Toolbar.
This adds the button to the QAT and allows you to open the PQ Editor with one click.
There are at least two options for keyboard shortcuts to open the Power Query Editor.
Quick Access Toolbar Shortcut
First, if you add the “Launch Power Query Editor” button to the QAT, you can use the Alt+Number shortcut to press the button. The number you press after Alt is determined by the position of the button in the QAT. And the button can be moved left to a lower number.
In the screenshot above I've moved the Launch Power Query button to the third position in the QAT. So, Alt+3 is the customized keyboard shortcut for me to open Power Query.
Checkout this post on Keyboard Shortcuts for the Quick Access Toolbar to learn more.
Alt Sequence Shortcut
The keyboard shortcut to open the Power Query Editor is: Alt, A, P, N, L
Those are the accelerator keys for the Data tab (A), Get Data menu (PN), and Launch Power Query Editor button (L). It's a long one to commit to remember. Leave a comment below if you think of a good acronym to help remember this one. 🙂
Note: This Alt sequence shortcut will only work if you are on Excel 2016 or later for Windows. Power Query was an add-in with it's own ribbon tab before that. The Alt sequence will be a bit different.
Free Training Webinar on Power Query
If you're still new to Power Query and/or not exactly sure what it does and how it can help save you a TON of time with your work, then right now I'm running a free training webinar on all of the Power Tools in Excel. This includes Power Query, Power Pivot, Power BI, pivot tables, macros & VBA, and more.
It's called The Modern Excel Blueprint. During the webinar I explain what these tools are and how they can fit into your workflow.
You will also learn how to become the Excel Hero of your organization, that go-to gal or guy that everyone relies on for Excel help and fun projects.
The webinar is running at multiple days and times. Please click the link below to get registered and save your seat.
Do you know of any other shortcuts for opening the Power Query Editor? If so, please share and leave a comment below. Thank you! 🙂