Yes, you can hide columns in an Excel pivot table by right-clicking a column header and selecting Hide, or by unchecking the field in the PivotTable Field List. This removes the column from the pivot view without deleting the source data or the field from the pivot cache. Below I explain every method, what each does, and the common pitfalls to avoid.
Why Hide Columns in a Pivot Table?
Pivot tables often generate more columns than you want to display. For example, a sales pivot with Region in the Columns area might show East, West, North, South, and a Grand Total. You may only want East and West for a regional report. Hiding columns lets you focus the view without rebuilding the pivot or removing fields entirely. It also helps when you have many date columns (e.g., daily sales for a month) and you only need weekdays or a specific date range.
Hiding is different from deleting. The hidden column’s data remains in the pivot cache, so if you later unhide it, the values are still there. This is useful for toggling between detailed and summary views.
Method 1: Right-Click and Hide
The fastest way to hide a single column (or multiple contiguous columns):
- Click any cell inside the column you want to hide.
- Right-click the cell (or the column header area).
- Choose Hide from the context menu.
To hide several columns at once, select a range of cells across those columns first (e.g., click a cell in column C, hold Shift, click a cell in column E), then right-click and choose Hide. This works for columns that are next to each other. For non-adjacent columns, hold Ctrl while selecting cells in each column, then right-click and Hide.
On a Mac, the right-click is Ctrl+click or two-finger tap on a trackpad. The menu is identical.
Method 2: Uncheck Fields in the Field List
If the column corresponds to a field item (like a specific region or a specific date), you can remove it from the pivot entirely:
- Click anywhere in the pivot table to show the PivotTable Fields pane on the right.
- Find the field that is placed in the Columns area.
- Click the checkbox next to the field – unchecking it removes all columns for that field.
But this removes the entire field, not just one item. To hide a single item (e.g., only the “North” region), you need to use the field’s dropdown:
- In the pivot table, click the arrow on the column header (the one that says “Column Labels” or the field name).
- Uncheck the specific item you want to hide (e.g., uncheck “North”).
- Click OK.
This method keeps the field in the pivot but excludes the selected item from display. Note that this also filters the underlying data for that field – the item’s values are not shown anywhere in the pivot.
Method 3: Hide the Entire Column (Not Just Pivot Data)
Sometimes you want to hide the physical worksheet column that contains the pivot output. This is different from hiding a pivot field item. For example, if your pivot table occupies columns A through F and you only want to show A through D, you can hide columns E and F on the worksheet:
- Select the column letters E and F (click the “E” header, drag to “F”).
- Right-click the selected headers.
- Choose Hide.
This hides the entire worksheet columns, which may also hide data outside the pivot if you have other content in those columns. Use this only when the pivot is the only thing in that area. To unhide, select columns D and G, right-click, and choose Unhide.
How to Unhide Columns
To bring back a hidden pivot column:
- If you used right-click Hide, right-click any cell in the column to the left or right of the hidden one, then choose Unhide. You may need to select a range that spans the hidden column (e.g., if column C is hidden, select B and D, then right-click → Unhide).
- If you unhecked an item in the field dropdown, go back to the dropdown and re-check the item.
- If you hid worksheet columns, select the surrounding columns and use Unhide as described above.
Common Problems and Misconceptions
Problem: Hidden columns still appear when you refresh the pivot.
If you hid a specific item via the field dropdown, refreshing the pivot may bring it back if new data adds that item again. To permanently exclude an item, use a filter (drag the field to the Filters area) or create a slicer and deselect the item. The right-click Hide method is temporary and will be lost when you refresh or change the pivot layout.
Misconception: Hiding a column deletes the data.
It does not. The data remains in the source and in the pivot cache. Hiding only affects the display. If you delete the column from the pivot (by removing the field), the data is still in the source but no longer summarized.
Problem: You cannot hide the Grand Total column.
You can. Right-click the Grand Total header and choose Remove Grand Total (or go to PivotTable Design > Grand Totals > Off for Rows and Columns). This is a separate setting from hiding a regular column.
Problem: Hidden columns reappear when you change a filter or slicer.
That’s expected. When you filter the pivot, items that were hidden via right-click may be recalculated and shown again. Use the field dropdown method to keep items excluded consistently.
Alternatives to Hiding Columns
If you frequently need to show different subsets of columns, consider these more robust options:
- Slicers – Connect a slicer to the field in the Columns area. Users can click to include or exclude items without right-clicking. Slicers are visual and work well in dashboards.
- Filters area – Move the field from Columns to Filters. The field becomes a dropdown above the pivot, letting you pick one item at a time (or multiple if you enable “Select Multiple Items”).
- Grouping – For dates, group by month or quarter to reduce the number of columns. Right-click a date column > Group > choose Month/Quarter.
- PivotTable Options – In PivotTable Options > Display, you can turn off “Show expand/collapse buttons” or “Classic PivotTable layout” to change how columns display.
Frequently Asked Questions
Can I hide multiple non-adjacent columns in one go?
Yes. Hold Ctrl and click a cell in each column you want to hide, then right-click any of those cells and choose Hide. Excel will hide all selected columns at once.
Why does my hidden column come back after I refresh?
Refreshing the pivot re-evaluates all fields and items. If you hid a column via right-click, that action is not recorded as a filter. To keep it hidden, use the field dropdown to uncheck the item, or add the field to the Filters area and select the items you want.
Does hiding a column affect the totals in other columns?
No. Hidden columns are simply not displayed; they are not excluded from calculations. If you hide a region column, the Grand Total still includes that region’s values. To exclude values from totals, you must filter the item out via the dropdown or a slicer.
Can I hide a column in a pivot chart?
Pivot charts reflect the pivot table’s visible data. If you hide a column in the pivot table, the chart will no longer show that series. To hide a series in the chart only, click the chart, then use the chart’s filter buttons (the funnel icon) to uncheck the series.
Is there a keyboard shortcut to hide a column?
No dedicated shortcut exists for pivot columns. However, you can use the right-click menu with the keyboard: select a cell, press Shift+F10 (Windows) or Ctrl+Enter (Mac) to open the context menu, then press H for Hide. On Mac, the shortcut is Ctrl+click then choose Hide.
What if I want to hide all columns except one?
Use the field dropdown on the column header, uncheck “Select All,” then check only the one item you want. This hides all other items for that field. Alternatively, move the field to the Filters area and select the single item from the dropdown.
Related
- Excel Conditional Formatting for Past Dates: How to Set It Up
- Excel Conditional Formatting for Past Dates
- Excel Conditional Formatting Duplicate Rows: Full Guide
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Power Pivot: How to Create a DAX Measure in ExcelTo create a measure in Excel Power Pivot for Microsoft 365 on Windows, open the Power Pivot tab,…
- Excel Line Chart: Ignore Null Values or Show GapsYes. In Excel for Microsoft 365 on Windows, you can control how a line chart handles empty cells:…
- Gantt Chart in Google Sheets: Build a Reusable TemplateYes. You can make a reusable Gantt chart in Google Sheets by listing tasks and their start and…
- Quadrant Chart in Google Sheets: How to Build OneGoogle Sheets does not have a dedicated quadrant-chart type, but you can make one with a scatter chart…
- Pivot Table Value Filter Not Working? Fix It in ExcelIf a PivotTable value filter is not working, first confirm that you applied it to a field in…
- Excel Trendline for Part of a GraphTo add a trendline to only part of an Excel graph, make a helper data series containing values…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.