Remove columns

If your query has columns you do not need, you may select columns that you want removed from your query.

Remove columns

Using the Query Editor ribbon

  1. Select the column (or columns with Ctrl+Click or Shift+Click) you want to remove.
  2. In the Query Editor ribbon, click Remove Columns > Remove Columns or Remove Other Columns to remove all columns except the selected column.

Using the Query Editor context menu

  1. Select the column (or columns with Ctrl+Click or Shift+Click) you want to remove.
  2. Right-click any selected columns.
  3. From the context menu, select Remove to not remove the selected columns, or Remove Other Columns to remove all columns except the selected column.
 
 
Applies to:
Excel 2013, Power BI for Office 365, Excel 2010