Excel Power Query: How to Hide or Remove Columns Easily

How-to basics · Updated November 21, 2026

In Excel Power Query, you cannot simply hide a column in the query editor the way you hide a worksheet column. To keep a field out of the query’s loaded results, select it and choose Home > Remove Columns; to conceal a column only on the worksheet, hide it after loading the query instead.

What “hide a column” means in Power Query

Power Query is Excel’s data-import and transformation tool, also known as Get & Transform. A query reads data from a source, applies a sequence of steps, and loads the resulting table into Excel or another destination. The query editor does not offer a worksheet-style hidden state for individual fields. A column is either part of the query’s result or it is excluded by a transformation.

This difference matters because hiding and removing have different effects. Hiding a worksheet column changes what is displayed in that sheet, but the column remains in the table and can still be used in formulas, filters, PivotTables, and other operations. Removing a column in Power Query excludes it from the result every time the query runs. It does not delete the field from the original source file, database, or table.

So first decide what you want: a cleaner view for people reading the worksheet, or a smaller output that does not contain certain fields. Choose the worksheet hide option for the first goal and a Power Query removal step for the second.

Remove a column from the query results

In Excel for Microsoft 365 on Windows, use these steps to exclude one or more fields from a query:

  1. Click a cell in the loaded query table, then choose Data > Queries & Connections. Double-click the query you want to edit. You can also open the query from the Queries & Connections pane.
  2. In Power Query Editor, select the column header. To select several non-adjacent columns, hold Ctrl while clicking their headers; to select adjacent columns, select the first and Shift-click the last.
  3. Choose Home > Remove Columns. Alternatively, right-click a selected header and choose Remove Columns.
  4. Choose Home > Close & Load to apply the change and return the updated result to Excel.

The removed field disappears from the query preview and the loaded output. Power Query records the removal as an applied step, so it is repeated when the query refreshes. If the field should stay in the source but not in this particular report, this is usually the right approach.

For a query that should keep only a small set of fields, select those fields and choose Home > Remove Columns > Remove Other Columns. The command keeps the selected columns and removes the rest. You can also use Home > Choose Columns to select the fields to include in a list, which can be easier when a table has many columns.

Keep worksheet data but conceal a column

If the query output should still include the data, load or refresh the query first and hide the column on the worksheet. Select its worksheet column letter, then choose Home > Format > Hide & Unhide > Hide Columns. On Windows, Ctrl+0 also hides the selected column in many Excel setups. The worksheet’s Unhide command restores it; for example, select the columns on either side of the hidden one and use Home > Format > Hide & Unhide > Unhide Columns.

On Excel for Mac, use the ribbon’s Format and Hide & Unhide controls if the Windows shortcut is unavailable or behaves differently. Excel for the web has its own ribbon layout, so look for the column hide command in the Home formatting options. Menu names and availability can vary somewhat by platform and update.

Hiding a column is a display choice, not a security measure. Anyone with access to the workbook may be able to unhide it, and its values remain in the workbook. Do not rely on hiding columns to protect confidential information. If the values must not be included in the output at all, remove them in Power Query and consider whether they also need to be excluded from the source or shared file.

Choose between Remove Columns and Remove Other Columns

The two removal commands solve opposite problems. Remove Columns is useful when a query should retain most of its fields but omit a few known ones. Remove Other Columns is useful when you know exactly which fields should remain and want to discard everything else.

  • Remove Columns: Select fields such as InternalNote and OldCode, then remove those fields. Other existing fields remain in the result.
  • Remove Other Columns: Select fields such as OrderDate, Region, and Revenue, then remove everything except those three.
  • Choose Columns: Open a checklist of available columns and mark the ones the query should include. This is helpful when scrolling through a wide table or choosing from a long field list.

Think about how the source may change. If you remove a short list of unwanted columns, a newly added source column may remain in the query output because the step removes only the named fields. If you use Remove Other Columns, new source columns are generally left out because the step keeps only the selected names. That can be a useful safeguard for a fixed report, but it can also mean a newly added field will not appear until you edit the query.

How Power Query applies the change

Power Query keeps transformations in an ordered list called Applied Steps, usually visible on the right side of the editor. Removing a column adds a step to that list. The step refers to the preceding result and changes the data passed to later steps; it does not alter the original source. On refresh, Excel reads the source again and reapplies the saved steps.

For example, a removal step might appear in the formula bar or Advanced Editor as = Table.RemoveColumns(#"Changed Type", {"InternalNote"}). This is Power Query M language, not an Excel worksheet formula. A keep-only step might look like = Table.SelectColumns(#"Promoted Headers", {"OrderDate", "Region", "Revenue"}). The names in parentheses refer to an earlier step and the column names to include or remove.

If you remove the wrong field, select the X beside the relevant step in Applied Steps, or use the editor’s undo command soon after making the change. Removing a step can affect later transformations, especially if those later steps refer to the removed field. Review the preview and subsequent steps before closing and loading.

Column order, refreshes, and changing source data

Removing a column can change the shape of the output table, but it does not automatically solve every issue caused by source changes. A query may also contain steps for renaming columns, setting data types, rearranging fields, or filtering rows. If a source column is renamed or deleted, a later step that expects its old name may produce an error. Open the query editor, check the step that shows the error, and update or remove the affected step as appropriate.

After changing a query, use Data > Refresh All to refresh workbook queries, or right-click the query table and choose Refresh. If a field removed from the query still appears in a worksheet, check whether you are looking at the intended query output or a separate table. Also check whether an old column is outside the current table range rather than part of the refreshed result.

When your goal is just to make the worksheet easier to scan, hiding a loaded table column may be convenient. However, a refresh can change the table’s columns or layout depending on the query output and workbook setup. If a column must never be part of the refreshed result, exclude it in Power Query rather than depending on a worksheet hide setting.

Common problems and practical checks

  • The column reappears after refresh: Confirm that you removed it in Power Query, not only hid it on the worksheet. Then refresh the correct query.
  • Remove Other Columns dropped a new field: This is expected when the query is configured to keep only selected fields. Edit the keep-columns step or use Choose Columns to include the new field.
  • A step displays an error after removal: A later step may use the field you removed. Inspect Applied Steps and either retain the field until it is no longer needed or adjust the dependent step.
  • You cannot find the query: Select a cell in its output and open Data > Queries & Connections. If the result is not a query table, verify how it was created before changing the worksheet.
  • The source file still contains the column: That is normal. A Power Query removal changes the query output; it does not rewrite the source file.

Excel for Mac and Excel for the web

The main idea is the same across Excel platforms: exclude fields with a query transformation, or hide them in the worksheet if you only want to change what is displayed. In Excel for Microsoft 365 on Windows, the instructions above use the standard Power Query Editor ribbon. The editor’s layout and available connectors or commands can differ in Excel for Mac and Excel for the web, so use the corresponding query-editing controls available in your version.

If you share a workbook with people using different platforms, a Power Query removal is generally more consistent than relying on a particular keyboard shortcut to hide a worksheet column. Still, query editing and refresh support can depend on the platform, data source, and organizational settings. Test the workbook in the version your readers will use, especially if they need to refresh the query themselves.

Frequently Asked Questions

Can I hide a column inside Power Query without removing it?
No. Power Query does not provide a hidden-column state like an Excel worksheet. Exclude the field from the query result with Remove Columns, or load it and hide the worksheet column if it must remain available.

Does removing a column in Power Query delete it from the source?
No. The removal is a transformation in the query. The original source data remains unchanged; the field is simply omitted from the query’s output.

How do I hide a column in an Excel table after loading a query?
Select the worksheet column letter and choose Home > Format > Hide & Unhide > Hide Columns. The table still contains the field, even though the worksheet does not display it.

Why did a column return after I refreshed the query?
It may only have been hidden on the worksheet, or you may have refreshed a different query. Open the query editor and check Applied Steps for a removal step that excludes the field.

Should I use Remove Columns or Remove Other Columns?
Use Remove Columns to exclude a few unwanted fields while retaining the others. Use Remove Other Columns when you want to specify a fixed set of fields to keep; remember that new source fields will not automatically join that set.

Which approach should you use?

Use Power Query’s Remove Columns or Choose Columns when a field should not be part of the refreshed dataset. Use Remove Other Columns when the output needs a deliberate, limited set of fields. Hide a worksheet column only when the data should remain available but does not need to be visible in the current view. Keeping that distinction in mind makes refreshes more predictable and helps prevent accidental reliance on a visual setting to control what data the query returns.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.