Excel Pivot Table Hide Filter: What You Can Remove

Charts & pivot tables · Updated November 19, 2026

To hide Excel PivotTable filter arrows without removing the current filter, select the PivotTable and choose PivotTable Analyze > Show > Field Headers to turn field headers off. This hides the field captions and filter drop-down buttons; it does not by itself clear the selections already filtering the PivotTable.

What does hide filter mean in a PivotTable?

People use “hide filter” to mean several different things in Excel. A PivotTable can have drop-down arrows beside row and column labels, a report filter above the table, slicers or timelines, and filters that exclude particular items. Hiding a control is different from removing a field or changing which data appears.

For example, imagine a sales PivotTable filtered to show the West region. Turning off field headers can conceal the arrows while leaving the West-only results on screen. Removing Region from the Filters area, by contrast, removes that report-filter field and generally returns the PivotTable to showing all regions. Clearing the filter also changes the results, even if the filter control remains visible.

Before changing the layout, decide whether you want to make the report look cleaner, prevent casual interaction, or change the data being summarized. Those goals call for different actions. A hidden arrow is a presentation choice; it is not a security feature and does not erase or conceal the underlying source data.

Hide the PivotTable field headers and arrows

In Excel for Microsoft 365 on Windows, use the Field Headers command to hide the PivotTable’s field captions and filter drop-down buttons:

  1. Click a cell inside the PivotTable. The PivotTable-specific ribbon tabs appear.
  2. Open PivotTable Analyze.
  3. In the Show group, click Field Headers to switch the display off.

Click the same command again to restore the headers and arrows. The change affects the PivotTable display, not the source table. It is useful when a finished report should look more like a clean summary than an interactive analysis grid. Depending on the PivotTable layout, the control can also hide field captions that identify row or column fields, so check that readers can still understand what the displayed labels represent.

Hiding these controls does not mean the PivotTable has become permanently fixed. Its current filters and layout remain part of the PivotTable, and someone with access to the workbook may be able to restore the buttons or use other controls. If a specific report-filter area remains visible in your layout, inspect the result after toggling Field Headers rather than assuming every kind of control has disappeared identically.

Remove or conceal a report filter

A report filter is a field placed in the Filters area of the PivotTable Fields pane. It usually appears above the PivotTable as a field name and a selected value, with a drop-down arrow. There are two practical approaches, depending on whether you still need that field to filter the report.

  • Remove the report-filter field: Click the PivotTable, open the PivotTable Fields pane if it is not already open, and drag the field out of the Filters area or uncheck it. This removes that field from the PivotTable layout. It is not a way to hide the control while preserving its selected value; the displayed summary may expand to include more items.
  • Hide the worksheet row containing it: If you need to retain the report-filter setting but do not want that row in the printed or displayed report, select the row header and use the row’s Hide command. This hides the entire worksheet row, including any unrelated cells in it. Unhide the row to access the report filter again.

Hiding a worksheet row is a broad workaround, not a dedicated “hide this one report-filter arrow” setting. It can make the control hard for the workbook’s next user to find, and it may be unsuitable if that row contains a title, notes, or other information. If the main need is a clean presentation, consider placing the PivotTable on a report sheet and keeping its controls on a separate analysis sheet.

Keep filtering available with a slicer

If you want to hide the small drop-down buttons but still let readers change the view, a slicer can provide a more visible filter interface. Select the PivotTable, choose PivotTable Analyze > Insert Slicer, select the field you want users to filter by, and confirm. The slicer appears as a panel of buttons; selecting a button filters the PivotTable, and the slicer’s clear-filter button can restore the unfiltered selection.

You can use a slicer alongside hidden field headers. This makes sense for a dashboard where a clear Region or Year control is preferable to a tiny arrow. A slicer takes up worksheet space, so position it where it will not obscure the summary. If a slicer is not changing the PivotTable you expect, check that it is connected to that PivotTable: select the slicer and look for Slicer options to manage its report connections. PivotTables may not share a slicer connection if they were built from different sources or caches.

A timeline is a related visual control for date fields. It is not the same as hiding a filter; it gives users another way to select a date range. Use one only when the PivotTable’s date field and workbook support it.

Hiding filter arrows is not the same as filtering data

Turning off Field Headers changes what users see, but it does not automatically show all records or remove a filter that is already applied. Conversely, using a field’s drop-down menu to uncheck an item changes the PivotTable results while leaving the control available. This distinction matters when someone opens a report and sees only part of the expected data: the missing categories may be filtered out, not hidden by the display setting.

When a field’s drop-down is visible, open it and review the selected items or use its clear-filter option to remove that field’s filter. For a report filter, choose the all-items option if the goal is to show every item for that field. For row or column fields, check the menu’s filter indicators and selections. Clearing a filter changes the summary, so confirm that this is what you intend before saving or sharing the workbook.

Also distinguish a PivotTable filter from hiding worksheet rows or columns. A PivotTable filter controls which field items contribute to or appear in the report; hiding a worksheet row merely hides cells from view. Neither method protects the source data. For a workbook that contains sensitive information, control access to the file and its source data rather than relying on hidden arrows, hidden rows, or a polished report sheet.

Choose the right method for your report

The best option depends on whether the report should be interactive and whether the filter setting must remain in effect:

  • Clean up the whole PivotTable: Turn off Field Headers. Use this when the current layout should remain but the controls are distracting.
  • Keep an obvious user control: Add a slicer, then hide the small field buttons if appropriate.
  • Stop using a field in the report: Remove it from the Filters, Rows, or Columns area. Check how the results change afterward.
  • Preserve a report-filter selection but remove its row from view: Hide the worksheet row only if hiding all of its cells is acceptable.
  • Show all items again: Clear the relevant filter rather than hiding its arrow.

For a shared dashboard, it is often helpful to include a short note explaining the active selection, such as “Region: West,” if you hide the controls. Otherwise, readers may mistake a filtered total for a company-wide total. This is especially important when the PivotTable is copied into a presentation or exported to a static format, where the filtering interface may not be apparent.

Common problems and version differences

If Field Headers is unavailable or does not appear to change anything, first click inside the PivotTable. The PivotTable Analyze tab is contextual and may not be shown when another cell is selected. Ribbon groups can also be compressed when the Excel window is narrow, so widen the window or inspect the available commands on that tab.

If the arrows disappear but captions also vanish, that is expected behavior for a setting that controls field headers as well as filter buttons. Restore Field Headers if the resulting report is unclear. You can then use a slicer for a more prominent filtering interface or leave the headers on and improve the layout in another way.

Excel for Mac uses a different overall ribbon arrangement in some releases, but the PivotTable Analyze tab and Field Headers control are available in desktop Excel versions that support this PivotTable interface. In Excel for the web, PivotTable commands and layout options can differ from the Windows desktop version, and not every display control is exposed the same way. If the command is missing in a browser, open the workbook in desktop Excel and use the Windows steps above; do not assume that removing a field is equivalent to hiding its button.

Frequently Asked Questions

Can I hide just one PivotTable filter arrow?
Excel’s Field Headers command is a PivotTable-wide display control, rather than a simple per-arrow switch. To keep other filtering available, consider adding a slicer for the field users need, or redesign the layout so the unwanted field is not presented as a control.

Will hiding the filter arrow clear my current filter?
No. Turning off Field Headers hides the headers and buttons; it does not, by itself, clear the selections already applied. Verify the displayed values before sharing the workbook, because a filtered summary can still look like a complete total.

How do I remove the filter but show all PivotTable items?
Open the relevant field’s drop-down and clear its filter or choose the all-items setting. The exact wording depends on the field and filter type. This changes the report results but leaves the field control visible unless you separately hide field headers.

Can I hide a report filter without losing its selected value?
You can hide the worksheet row containing the report-filter control, but that hides every cell in the row and can make the control difficult to find. Removing the field from the Filters area is different: it removes the report-filter field and may change the displayed summary.

Does hiding PivotTable filters protect the data?
No. Hidden arrows and hidden worksheet rows are presentation choices, not access controls. They do not remove source records or reliably prevent someone with workbook access from inspecting or changing the PivotTable.

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.