Excel Pivot Table: Hide Columns Without Losing Data

Charts & pivot tables · Updated November 21, 2026

In Excel for Microsoft 365 on Windows, select the worksheet column letter above the PivotTable and choose Home > Format > Hide & Unhide > Hide Columns to hide that entire worksheet column. If you mean a category or field inside the PivotTable, use its filter or change the field layout instead; those options affect the report without hiding unrelated cells on the sheet.

What “hide a PivotTable column” can mean

The phrase can describe several different actions, and choosing the wrong one can make a report confusing. A PivotTable is displayed in ordinary worksheet cells, but its rows and columns are generated from fields in the source data. Hiding worksheet columns, filtering PivotTable items, and removing fields are therefore different operations.

  • Hide a worksheet column: Makes the whole sheet column invisible, including any cells above or below the PivotTable.
  • Filter out a column item: Excludes a particular category, such as one year or product, from the PivotTable display.
  • Remove or move a field: Changes the report structure, for example by taking Region out of the Columns area or moving it to Filters.
  • Hide a value field: Removes a measure, such as Sum of Sales, from the displayed report by removing it from the Values area.

These choices do not normally delete rows from the source data. Filtering or changing the layout changes what the PivotTable displays; hiding a worksheet column only conceals cells. The distinction matters if a PivotTable shares a worksheet with charts, notes, formulas, or another report.

Hide an entire worksheet column

Use this method when you really want the worksheet column itself to disappear. It can be useful for a narrow spacer column, a helper column, or a PivotTable column that is not needed in a printed view. The command affects the full worksheet column, not just the PivotTable.

  1. Find the letter at the top of the column you want to hide, such as C or D.
  2. Click the column letter. To hide several neighboring columns, drag across their letters or select the first letter, hold Shift, and select the last.
  3. On the ribbon, choose Home > Format > Hide & Unhide > Hide Columns. Alternatively, right-click a selected column letter and choose Hide.

Excel leaves the cells and their contents in place; it simply hides their display. If the selected column contains other worksheet content, that content disappears too. A hidden worksheet column is not a privacy or security feature: someone who can edit or inspect the workbook can unhide it.

To show the column again, select the visible column letters on both sides of the hidden area, right-click the selection, and choose Unhide. You can also use Home > Format > Hide & Unhide > Unhide Columns. If the hidden column is at the far left or right of the used area, select the whole sheet using the square at the top-left corner of the row and column headings, then use the Unhide Columns command. Excel for Mac has comparable column context-menu and Home-tab commands; the exact ribbon arrangement can vary slightly by release. In Excel for the web, right-click the column heading and use the hide or unhide command when available.

Hide a category from the PivotTable

If you want to remove one category rather than conceal a worksheet column, filter the field that creates that category. For example, suppose a PivotTable shows sales by product across columns and you want to leave out the discontinued product. Open the dropdown beside the relevant Column Labels field, clear the checkbox for that product, and select OK. The report will no longer show that item.

Depending on the layout and Excel version, the dropdown may appear next to a field name or label in the PivotTable. You can also select a cell containing the item and use the field’s filter dropdown. If the filter menu lists many items, its search box can help locate one. To bring the item back, reopen the dropdown, select it again, and apply the filter. A command such as Clear Filter can restore all items for that field.

Filtering is not the same as hiding the worksheet column that happens to display the item. It filters the PivotTable’s category and its associated values. That distinction is useful when the PivotTable is refreshed or rearranged, because the filter belongs to a field rather than to a fixed worksheet coordinate. Be aware that excluding an item also removes its contribution from the displayed totals; the remaining total may therefore be smaller than the full source-data total.

Remove a field or change its position

Sometimes the unwanted column is not one category but an entire field. For example, a report may have Month across the top and you may decide that the monthly breakdown is unnecessary. Click inside the PivotTable to show the PivotTable tabs, then open PivotTable Analyze > Field List if the field list is not visible. In the field list, locate the field and inspect the areas named Filters, Columns, Rows, and Values.

To remove a field from the report, drag it out of its area in the field list, or clear its checkbox when that action removes it from the layout. To preserve the field as a report control without displaying it as a column, drag it from Columns to Filters. To show its categories down the side instead, move it to Rows. The best placement depends on what comparison the report is meant to support.

Removing a field from the PivotTable layout does not erase the corresponding source-data column. You can add the field back from the field list later. However, if you remove a field that determines the column categories, the PivotTable may regroup values into a broader total. Check the report’s totals after changing the layout, especially when the field separates time periods, regions, or product types that readers expect to compare.

Choose the method that matches your goal

Before hiding anything, identify whether the unwanted element is a worksheet coordinate, a category, or a measure. This quick comparison can prevent the common mistake of hiding a whole sheet column when the goal is only to filter one PivotTable item.

  • Use Hide Columns when the entire worksheet column should be out of sight and nothing else in that column needs to remain visible.
  • Use a field filter when a particular category, such as one region or product, should be excluded from the report.
  • Move a field to Filters when readers should be able to choose a category but it does not need to appear as a row or column label.
  • Remove a field from the layout when that breakdown is not useful in the current report.
  • Remove a value field from Values when a measure, such as Count of Orders, should no longer be displayed.

For a report that must remain easy to understand, filtering or rearranging fields is usually clearer than hiding worksheet columns. A hidden column can make a PivotTable look as though data is missing, and it can also conceal unrelated content. If the goal is a clean printout, consider whether a separate presentation sheet or a copied report would be safer than hiding columns in a worksheet that also supports analysis.

Refreshes, layout changes, and common problems

Hiding a worksheet column does not stop a PivotTable from refreshing. A refresh can update the PivotTable from its source, but a hidden worksheet column remains a sheet-level display setting. If the PivotTable expands into neighboring columns after a refresh or a layout change, a hidden column can make part of the updated report seem absent. Review the visible layout after refreshing, particularly when new categories have been added to the source data.

Filtering a field can also produce a surprising result if the filter applies to a different field than expected. Check the field name beside the dropdown before clearing an item. If a category is missing after a refresh, reopen that field’s dropdown and check whether it remains excluded. A PivotTable’s layout and filter settings can affect what is displayed, while the source data remains unchanged.

  • Hide or Unhide is unavailable: Make sure you selected the worksheet column heading, not just a cell inside the PivotTable. A protected sheet may also prevent changes; check the Review tab and the workbook’s protection settings.
  • You cannot find a hidden column: Look for a jump in the column letters, such as B followed by D, then select the surrounding headings and choose Unhide.
  • The wrong information disappeared: Unhide the worksheet column first. Then use the PivotTable filter or field list if you meant to change only the report.
  • The column reappears or the report shifts: Check whether the PivotTable’s layout changed, whether the report expanded, and whether the relevant field filter is still applied.

When the workbook contains multiple PivotTables, remember that hiding a worksheet column affects every cell in that column, even cells belonging to other reports. Field filters and layouts are generally more targeted. If a worksheet is protected or shared, make sure you have permission to change its structure before trying to hide or unhide columns.

Frequently Asked Questions

Can I hide just one column inside a PivotTable?
Yes, if you mean the worksheet column that contains it: select that column heading and use Hide. This hides the entire worksheet column, not only the PivotTable cells. For one category or field item, use the PivotTable filter instead.

Does hiding a PivotTable column delete the data?
No. Hiding a worksheet column only conceals its cells, and filtering or removing a field changes the report rather than deleting source rows. The underlying source data remains in the workbook unless you separately edit or delete it.

How do I hide a PivotTable column without changing the source data?
Use the column heading’s Hide command to conceal a worksheet column, or filter an item or move a field in the PivotTable to change the report. Neither action requires deleting the source-data column.

Why can I still see a field in the PivotTable Field List?
The field list represents fields available from the PivotTable’s source, not only fields currently displayed. Removing a field from Rows, Columns, Values, or Filters removes it from the current layout but generally leaves it available to add again.

Will a refresh unhide a worksheet column?
Refreshing updates the PivotTable’s data and report, while worksheet-column visibility is a separate sheet setting. The column generally stays hidden, but the report’s size or arrangement can change, so inspect the worksheet after a refresh.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

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

Spotted an error in this guide? Let us know.