Pivot Table Issues

How to Remove Expand and Collapse Buttons from an Excel PivotTable Filter

Khadija Khan Oct 10, 2026 868 views

Question details

The user wants to remove the Expand (+) and Collapse (-) controls from a PivotTable filter field and restore the standard drop-down filter list.

How to Remove Expand and Collapse Buttons from an Excel PivotTable Filter

Product: Microsoft Excel
Device & OS: not provided
Scenario: Filtering items within a PivotTable field where the interface behaves differently than expected.
Observed behavior: Items in the PivotTable filter field appear with Expand and Collapse controls (+/-) instead of the usual flat filter list.

Before you start

Ensure you click on a cell within your active PivotTable to make the PivotTable Analyze or Options tabs visible on the Excel ribbon.

Solution 1Recommended

Recreate the PivotTable Without the Data Model

The primary cause of the expand/collapse behavior in filters is adding the source data to the Excel Data Model. Recreating the PivotTable without the Data Model restores the standard filter list.

When a PivotTable uses the Data Model (Power Pivot), fields are structured as hierarchies, which replaces standard filters with Expand/Collapse buttons. This is a design setting for Data Model PivotTables and cannot be toggled off for an existing table.

Select your source data

Highlight the range of cells or the table that contains your source data.

Insert a new PivotTable

Navigate to the 'Insert' tab on the ribbon and click 'PivotTable'.

Uncheck the Data Model option

In the Create PivotTable dialog box, look at the bottom and ensure the checkbox for 'Add this data to the Data Model' is completely unchecked.

Build your fields

Click 'OK' and drag your fields into the Rows, Columns, and Filters areas. The filter will now behave normally without the expand/collapse buttons.

Recreate the PivotTable Without the Data Model

Solution 2

Hide Field Buttons via PivotTable Analyze Tab

If you just want to hide the plus and minus buttons visually on a standard PivotTable without recreating it, you can toggle them off from the ribbon.

Easily Manage PivotTables in WPS Spreadsheet

WPS Spreadsheet provides an intuitive, lightweight, and highly compatible interface for managing PivotTables. It allows you to seamlessly summarize and filter data without unexpected interface changes like forced expand/collapse buttons.

1. Open your workbook: Launch WPS Spreadsheet and open your existing Excel (.xlsx) workbook.
2. Insert a PivotTable: Select your data range, navigate to the 'Insert' tab, and click 'PivotTable'.
3. Arrange your fields: Drag and drop your desired fields into the Rows, Columns, Values, and Filters areas in the right-hand pane.
4. Filter normally: Click the filter drop-down arrow on any field header to use the standard, clutter-free filter list.

Fully compatible with Microsoft Excel (.xlsx) formats and existing PivotTables.Standard filter lists work reliably and are easy to configure.Lightweight software that loads quickly even when analyzing large datasets.Clean, user-friendly interface that prevents unexpected Data Model conflicts.

microsoft office alternative - wps office

Frequently Asked Questions

Why does my PivotTable have plus and minus signs instead of regular filters?

This usually occurs when the PivotTable is created by adding the source data to the Data Model. The Data Model changes how fields behave, structuring them as hierarchies with expand/collapse (+/-) buttons instead of standard flat filters.

Can I disable the Data Model for an existing PivotTable?

No, once a PivotTable is created using the Data Model, you cannot simply toggle the setting off. You must recreate the PivotTable from your source data and ensure the 'Add this data to the Data Model' option is unchecked.

How do I collapse all fields at once in a PivotTable?

Right-click any item in the field you want to collapse, hover over 'Expand/Collapse' in the context menu, and select 'Collapse Entire Field'. This will neatly roll up all items within that specific field hierarchy.

Excel & Data Problems