To hide the filter buttons in an Excel PivotTable without clearing its current filter selections, click anywhere in the PivotTable and choose PivotTable Analyze > Show > Field Headers to turn Field Headers off. The dropdown arrows disappear, but the filters already applied remain in effect; turn Field Headers back on when you need to change them.
Hide PivotTable filter buttons in Excel
In Excel for Microsoft 365 on Windows, use these steps:
- Click a cell inside the PivotTable. The PivotTable tabs appear on the ribbon.
- Open PivotTable Analyze.
- In the Show group, click Field Headers.
This setting is a toggle. When field headers are visible, clicking the command hides them and their filter dropdowns. Click it again to restore the headers and buttons. If the ribbon is narrow, the Show group or command may be collapsed; widen the Excel window or expand the group to find it.
You can also right-click inside the PivotTable, choose PivotTable Options, open the Display tab, and clear Display field captions and filter drop downs. Click OK to apply the change. This option is useful when you want to adjust the display through the PivotTable settings dialog rather than the ribbon.
What changes when field headers are hidden
Field headers identify the fields used to organize a PivotTable and usually contain dropdown arrows for filtering or sorting. Hiding them is a display change: it does not delete the source data, remove fields from the layout, or clear a filter selection. For example, if a report is currently filtered to show the West region, hiding the headers leaves the West-only results on screen. The filter remains active even though its dropdown is no longer visible.
The trade-off is that people viewing the report may not be able to tell which fields are in use or change the criteria from the PivotTable itself. If you hide headers on a shared report, consider adding a nearby note such as “Region: West” so readers understand the displayed results. The note is explanatory text, not a live link to the filter setting, so update it if the selection changes.
Hiding field headers also affects more than the arrow buttons: field captions can disappear as well. Captions are labels such as “Row Labels,” “Column Labels,” or the name of a field. Check the finished report for clarity, especially if a compact layout relies on those labels to explain what each part of the table represents.
Which buttons and labels are affected
PivotTables can show dropdowns in different places depending on their layout. Row and column field headers have dropdowns for filtering or sorting items. A report filter, sometimes called a filter field, appears above the PivotTable and lets a user select which item to display. The Field Headers setting controls the PivotTable’s field captions and filter dropdown display; after changing it, inspect the entire PivotTable, including the area above it, to confirm the result matches your intended design.
There is not generally a built-in ribbon command to hide just one field’s dropdown while leaving every other field header and dropdown untouched. If you turn Field Headers off, it is a PivotTable-level display choice, not a per-field formatting control. If your goal is to remove only one field from the report, use the PivotTable Fields pane to remove that field from the Rows, Columns, Filters, or Values area—but that changes the PivotTable layout and may change the report itself.
Also distinguish PivotTable dropdowns from Excel’s ordinary AutoFilter arrows. The Data tab’s Filter command is for filtering a regular data range or Excel table; it is not the control for the field-header buttons inside a PivotTable. Changing AutoFilter settings is therefore not the right fix for PivotTable field buttons.
Hide buttons or remove the filter itself?
Choose the display toggle when the filter criteria should continue limiting the report but viewers should not see the controls. Choose a different action if the data should no longer be filtered. To clear a specific filter, restore the field headers, open that field’s dropdown, and choose the relevant clear-filter command. The exact wording can depend on the field and filter type, but Excel identifies the field in the menu. You can also use the clear-filter command on the PivotTable Analyze tab when available for the selected PivotTable.
- Hide controls: Keep the current filtered results, but conceal field captions and dropdowns.
- Clear a filter: Show all eligible items for that field again.
- Remove a field: Take the field out of the PivotTable layout, changing how the summary is organized.
- Delete the PivotTable: Remove the summary report itself; this is not necessary just to hide its controls.
A frequent misconception is that a hidden filter has been cleared. It has not. If the report seems to be missing records after you hide the buttons, turn Field Headers back on and inspect the filter selections. Also check for filters on other row, column, or report fields; a PivotTable can have more than one active filter.
Alternatives for a cleaner interactive report
If readers need to change the results but the dropdown arrows look cluttered, keep the headers visible or add a slicer. A slicer is a visual filtering control with selectable buttons. To add one, click the PivotTable and choose PivotTable Analyze > Insert Slicer, select the field, and click OK. Slicers make the available choices more obvious, but they occupy worksheet space and do not replace every kind of filtering or sorting action.
For date fields, a timeline may be a convenient interactive control. Select the PivotTable and choose PivotTable Analyze > Insert Timeline, then select a date field. Timelines are for date filtering and are not a general substitute for dropdowns on text or numeric fields. If the PivotTable shares a data source with other PivotTables, a slicer can sometimes control more than one report: select the slicer and use its Report Connections command to choose the PivotTables it should affect, where supported by their shared source.
Another option is to leave the controls visible but make the report easier to read by adjusting column widths, applying a PivotTable style, and placing the report title and instructions outside the PivotTable. Avoid putting important notes directly where a refresh or layout change could overwrite them. If you need a fixed, noninteractive presentation, you can copy the PivotTable results and paste values elsewhere, but that copy will no longer update as a PivotTable when the source data changes.
Common problems and checks
- The command is missing: Click inside the PivotTable first. The contextual PivotTable Analyze tab is not shown as a PivotTable tab when a normal worksheet cell is selected.
- The arrows are still visible: Confirm Field Headers is off and check whether the visible arrow belongs to a slicer, timeline, or regular Excel table rather than the PivotTable.
- The report still shows only some records: Hiding headers preserves active filters. Turn the headers back on and review all filter fields.
- The labels disappeared too: That is expected when field captions are hidden. Restore Field Headers if the report needs those labels for context.
- The menu looks different: Ribbon layout and available controls can vary with window size, updates, and the selected object. Look for Field Headers on the PivotTable Analyze tab or use PivotTable Options.
Refreshing a PivotTable updates its summary from the source data; it is separate from showing or hiding field headers. A refresh can affect which items appear in field menus, especially if the source data has changed, but it does not make the Field Headers toggle a filter-clearing command. After refreshing a report used by other people, verify both the displayed results and any hidden selections.
Excel for Mac and Excel for the web
In current Excel for Mac, click the PivotTable and look for the PivotTable Analyze tab and its Field Headers control. Ribbon organization can differ from Windows, so the PivotTable Options dialog may be an alternative if the command is not immediately visible. Mac keyboard shortcuts also differ from Windows in many Excel tasks, but no keyboard shortcut is required for this setting.
Excel for the web has a more compact ribbon and may expose PivotTable commands differently from the desktop app. Select the PivotTable and look for its PivotTable-related ribbon tab and field-header display control. If the option is unavailable in the web interface, open the workbook in the Excel desktop app to change the display setting. These interface differences do not change the key distinction: hiding a button is not the same as clearing the filter selection.
Frequently Asked Questions
Does hiding PivotTable filter buttons clear the filters?
No. Turning off Field Headers hides the field captions and dropdown controls; existing filter selections remain active. Restore the headers to inspect or change those selections.
Can I hide one filter button but keep the others?
Excel’s Field Headers control is a PivotTable-level display setting, not a simple per-field button toggle. You can remove a field from the layout, but that changes the report. A slicer may be a better alternative if users still need an obvious way to filter.
How do I get the filter buttons back?
Click inside the PivotTable, then choose PivotTable Analyze > Show > Field Headers again. In PivotTable Options, select Display field captions and filter drop downs instead.
Why does my PivotTable still show filtered results after I hide the arrows?
Because the filter remains applied. Turn Field Headers back on and review the field dropdowns, including any report filters above the PivotTable, to find the selection limiting the results.
Can I use a slicer instead of PivotTable filter buttons?
Often, yes. Insert a slicer for a field to give users a visual way to select items. It takes worksheet space and has different capabilities from a field dropdown, so check that it supports the interactions your report needs.
Related
- Excel Number Custom Format Codes: Examples and Tips
- Excel No Color Fill: How to Remove a Cell’s Background
- Excel Not Letting You Insert an Image? Causes and Fixes
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Area Chart Change Order: Move Series CorrectlyTo change the order of series in an Excel area chart, select the chart and choose Chart Design…
- Excel Gantt Chart Dates: Formulas, Setup, and TipsFor a basic Excel Gantt chart, calculate each task’s finish date with =B5+C5-1 when B5 is its start…
- Excel Pivot Chart Without a PivotTable: What WorksYou can create an Excel PivotChart from a normal cell range without first converting the source data into…
- Excel Waterfall Charts with Multiple Series ExplainedNo—not as separate, independent series in Excel’s built-in Waterfall chart. In Microsoft 365 for Windows, a native waterfall…
- Excel Speedometer Chart: Build One and Make It WorkAn Excel speedometer chart is a dashboard-style gauge that shows a value on a semicircular scale; Excel does…
- Creating a Waterfall Chart in Excel: A Step-by-Step GuideTo create a waterfall chart in Excel for Microsoft 365 on Windows, put each step of the change…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.