Remove columns (Power Query)

If your query has columns you don't need, you can remove them. You can select one or more columns, and then either remove the selected ones, or remove the unselected ones, that is the other columns.

Consider the difference between removing a column and removing other columns. When you choose to remove other columns, and then you refresh your data, new columns added to the data source since your last refresh operation might remain undetected because they would be considered other columns when the Remove Column step is again executed in the query. This situation won’t occur if you explicitly remove a column. The new columns added since the last refresh would still appear in Data Preview.

  1. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

  2. Do one or more of the following:

    • To remove a single column, select the column you want to remove, and then select Home Remove Columns > Remove Columns.

    • To remove several columns, select the columns by using Ctrl + Click or Shift + Click. The columns can be contiguous or discontiguous.

    • To remove all columns except the selected column, select one or more columns, and then select Remove Other Columns.

See Also

Power Query for Excel Help

Choose or remove columns (docs.com)

Need more help?

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×