Pivot Table Issues

How to Fix Blank PivotTable Fields Areas in Excel

Maira Mehtab Sep 24, 2026 869 views

Question details

The Filters, Columns, Rows, and Values areas inside the PivotTable Fields pane are not visible or appear completely blank.

Product: Microsoft Excel for Microsoft 365
Device & OS: not provided
Scenario: Managing data using PivotTables and attempting to drag or view fields in the PivotTable Fields pane.
Observed behavior: The bottom sections of the PivotTable Fields pane (Filters, Columns, Rows, Values) appear blank, even after updating or reinstalling the application.

Before you start

Ensure that you have clicked inside an active PivotTable so that the PivotTable Fields pane is visible on the right side of your screen.

Solution 1Recommended

Change the PivotTable Fields Pane Layout

Adjust the layout settings within the PivotTable Fields pane to instantly restore the visibility of the field areas.

This issue is typically caused by an accidental change to the layout view of the PivotTable Fields pane rather than a software corruption. Reinstalling or updating the software will not resolve it because Excel remembers your layout preferences.

Open PivotTable Fields Pane

Click anywhere inside your existing PivotTable in the worksheet to make the PivotTable Fields pane appear on the right.

Access Tools Menu

Click the Tools (gear icon) located near the top right corner of the PivotTable Fields pane.

Select Stacked Layout

From the drop-down menu, choose 'Fields Section and Areas Section Stacked'. This will instantly restore the missing Filters, Columns, Rows, and Values areas.

Layout Restored: Your PivotTable field areas should now be fully visible and ready for data to be dragged into them.

Create PivotTables Seamlessly in WPS Office

Manage PivotTables Easily in WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and stable environment for data analysis. You can create, manage, and customize PivotTables without worrying about missing panes or persistent layout bugs.

1. Open Data: Launch WPS Spreadsheet and open your data workbook.
2. Insert PivotTable: Select your data range, navigate to the 'Insert' tab on the ribbon, and click 'PivotTable'.
3. Choose Location: Select whether to place the PivotTable on a new worksheet or an existing one, then click 'OK'.
4. Manage Fields: Use the robust PivotTable Fields pane on the right to effortlessly drag fields into the Filters, Columns, Rows, and Values areas.

Fully compatible with Microsoft Excel (.xlsx) formats and PivotTable structures.Intuitive and stable PivotTable Fields pane for seamless data drag-and-drop operations.Free and lightweight office suite with a familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my PivotTable field areas suddenly disappear?

This usually happens when the layout setting of the PivotTable Fields pane is accidentally changed to only show the 'Fields Section'. Restoring the 'Stacked' layout via the gear icon will fix it.

How do I bring back a completely missing PivotTable Fields pane?

First, click anywhere inside your PivotTable. If the pane still doesn't appear, go to the 'PivotTable Analyze' (or Options) tab on the ribbon and click 'Field List' in the Show group.

Will reinstalling Excel fix PivotTable pane layout issues?

No, reinstalling or updating Excel often preserves your personalized layout preferences. You must manually reset the pane layout via the Tools gear icon in the PivotTable Fields pane.

Excel & Data Problems