Stop ignoring the Applied Steps pane: 5 Power Query tricks for faster data cleanup

Ignoring the Applied Steps pane in the Power Query editor means you're stuck in a loop of trial and error. That's how you end up with a bloated workflow that turns a five-minute cleanup into an afternoon chore. You don't need to learn any code to fix this—you just need to learn how to manipulate your existing steps.

Here are five ways to use the pane for lightning-fast, non-destructive data edits.

To follow along in Excel, you'll need to open the Power Query Editor. If you already have a query, go to Data > Connections & Queries, right-click your query, and select Edit. If you're starting from scratch with an Excel table, select any cell in your data and go to Data > From Table/Range. In Power BI, select your data source and click Transform Data.

Review individual steps to find and fix errors

Identify and delete the transformation that broke your data

You've spent 20 minutes meticulously transforming your data, only to realize that a crucial ID column has vanished. Somewhere along the line, it was dropped, filtered, or merged out of existence.

In a standard spreadsheet, you'd press Ctrl+Z repeatedly, effectively vaporizing all the good work you've done. In Power Query, you can toggle between the step where the data exists and the step where it disappears to identify the transformation that caused the issue.

To find your error, start at the bottom of the Applied Steps pane and click each step in turn, moving upward.

As you click, watch the Data Preview window. The moment your missing column or broken value reappears, you've found the step immediately before the error occurred. For example, when I select the Replaced Value step, the Item# column reappears, indicating the issue occurred in the next step (Removed Columns).

Now that you've located the problematic step, click the X to the left of the step name. A warning may appear asking if you're sure—click Delete.

Your missing data instantly flows back into every subsequent step, fixing your dataset without losing your other transformations.

Insert transformations mid-stream

Add new steps without undoing your progress

Sometimes the problem isn't a bad transformation—it's a missing one. If you need to add a new filter or calculation to the beginning of a long process in a regular Excel sheet, you might have to undo all your hard work. However, in Power Query, you can slide a new instruction into the middle, and—as long as you're not removing or renaming something a later step depends on—the rest of the query will adjust automatically.

In the Applied Steps pane, select the step immediately before where you want your new transformation to go.

Now, perform your new step. Here, I want to filter out Stationery from the Department column. If you see a warning asking whether you want to insert a step between existing transformations, click Insert. Power Query is simply confirming that later steps depend on the current output.

Finally, click back down to the final step in your list to see that your new mid-stream edit has been threaded into the workflow.

Tweak settings using the gear icon

Fix the logic without adding more steps

Sometimes you don't need to add a new step at all—you just need to tweak a decision you have already made, such as adding an extra filter layer or changing the delimiter in a text split.

Locate a step in the Applied Steps pane that has a gear icon next to its name, and click the icon to open the transformation's settings window.

Only the steps that rely on a dialog box or drop-down menu during their initial setup can be edited this way. Simple actions like deleting a column don't have this option.

Modify your criteria, such as adding a second filter value or updating the file path in the Source step, and click OK.

Power Query recalculates the entire query based on your updated logic, and all subsequent steps automatically reflect the change.

Document your work as you go

Explain your logic to your future self

While Power Query gives steps default names like Filtered Rows, they don't tell you why you made that transformation. That's why it lets you attach a plain-English description to any transformation, turning your Applied Steps pane into a self-documenting manual without cluttering the workspace.

Right-click any step in the Applied Steps pane and select Properties.

In the Description box, type a brief explanation of why this step exists or what specific data it's targeting, and click OK.

Any step with a note attached to it adopts a small i icon, and you can hover your cursor over the step to quickly remind yourself of what you wrote.

While you're in the Properties dialog, you can also change the Name field to give your step a more meaningful label (like "Fix Item Typo" instead of "Replaced Value"). Alternatively, you can quickly rename any step by selecting it and pressing F2.

Remove the automatic Changed Type step

Stop Power Query from guessing your data types too early

Whenever you connect to a new data source, Power Query automatically adds a Changed Type step near the start of your list by scanning a sample of your data to make an educated guess about what each column contains.

Data types in the editor tell Power Query how each column should behave during transformations—like enabling math for numbers and date filters for years. While they don't automatically apply number formatting to your worksheet, they do control how calculations run inside the query.

While this seems helpful, if your source data changes later—such as columns being renamed or containing unexpected values—this automatic step can trigger errors during refresh. So, as soon as you upload your dataset to the editor, delete this automatic Changed Type step by clicking the X next to it.

Once you've finished performing your initial cleaning steps—such as removing unnecessary columns or renaming headers—it's time to reset the data types:

1. Activate the final step in the Applied Steps pane (so that the one you're about to perform falls after it).
2. To set the data type for multiple similar columns simultaneously, hold Ctrl as you select them, and use the Data Type drop-down menu in the Transform tab.
3. To quickly set data types for individual columns, use the icon to the left of each column header.

You've now unlocked the correct tools in the ribbon for the rest of your transformations.

If you hate manually deleting the auto-type step every time, in the editor, click File > Options and settings > Query Options, and disable automatic type detection (exact UI wording may vary by version).

---

By taking control of the steps in your query, you turn one-off fixes into resilient, repeatable workflows that won't fall apart next month. This kind of precision is exactly why so many of us find that Power Query handles everyday Excel actions better than wrestling with complex formulas or tedious manual entry.