The Alt sequence will be a bit different. Power Query was an add-in with it's own ribbon tab before that.
Note: This Alt sequence shortcut will only work if you are on Excel 2016 or later for Windows. Leave a comment below if you think of a good acronym to help remember this one. Those are the accelerator keys for the Data tab (A), Get Data menu (PN), and Launch Power Query Editor button (L). The keyboard shortcut to open the Power Query Editor is: Alt, A, P, N, L So, Alt+ 3 is the customized keyboard shortcut for me to open Power Query.Ĭheckout this post on Keyboard Shortcuts for the Quick Access Toolbar to learn more.
In the screenshot above I've moved the Launch Power Query button to the third position in the QAT. And the button can be moved left to a lower number. The number you press after Alt is determined by the position of the button in the QAT. Quick Access Toolbar Shortcutįirst, if you add the “Launch Power Query Editor” button to the QAT, you can use the Alt+Number shortcut to press the button. There are at least two options for keyboard shortcuts to open the Power Query Editor. This adds the button to the QAT and allows you to open the PQ Editor with one click. You can right-click the item in the Get Data menu, then select Add to Quick Access Toolbar. The “Launch Power Query Editor” button can be added to the Quick Access Toolbar (QAT). However, there a few ways to get there faster. Getting to this button is going to require multiple clicks, especially if you're not on the Data tab. 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. In this post we'll look at a few shortcuts, including keyboard shortcuts, to make this process faster.Ĭheck out my posts on an Overview of Power Query and How to Install Power Query if you are on an older version of Excel. There are quite a few ways to open this window. Power Query is currently a separate window that opens on top of Excel. Once you start using it, you'll want to get to the PQ Editor window quickly. Power Query (PQ) is an amazing tool that allows us to automate data transformations in Excel. Skill level: Intermediate The Window to a Whole New World in Excel Bottom line: Learn a few shortcuts to quickly open the Power Query Editor in Excel.
0 kommentar(er)
