Just one more method for you to try, select any cell in query table.
Click the Edit option at the bottom.Īnother method is to open the Power Query editor without selecting a specific query.Ĭlick Data -> Get Data -> Launch Power Query Editor. When hovering over a query (don’t click, just hover), Excel displays the query summary. Within the Queries & Connections window, we can right-click on the query and select edit. The Queries & Connections window will open, simply double-click on the name of a query. The easiest method is to click Data -> Queries & Connections from the ribbon. I will briefly cover the most common below, though we only really need to know one or two. Opening Power Query to edit an existing query is no different, there are loads of ways to do it. Edit an existing queryĪs with many features of Power Query, there are multiple ways to access the same action. Open the up the file and let’s get going. It is an Excel workbook which already contains some basic queries.
Then you’ll be able to work along with examples and see the solution in action, plus the file will be useful for future reference.ĭownload the file: Power Query – Example FilesĪll the examples in this post use Example 7 – Edit Queries.xlsx from the downloads. I recommend you download the example file for this post. We’ve seen a small piece of this in a previous post, but now we’ll go a lot deeper.
#Excel 2016 query editor insert a new step how to
In this part of the Power Query series, we will look at how to edit queries.