Sign in with Microsoft
Sign in or create an account.
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 (

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!