Restore Filters, Rows, Columns, and Values Areas in an Excel PivotTable
Question details
Restore the Filters, Columns, Rows, and Values drop areas in the PivotTable Fields pane.
- Product
- Microsoft Excel PivotTable
- Device & OS
- not provided
- Scenario
- The user needs to arrange PivotTable fields but the area section at the bottom of the PivotTable Fields pane is missing.
- Observed behavior
- The PivotTable Fields pane displays only the field list because it is using a field-only layout, or the entire Field List pane is hidden.
Click any cell inside the PivotTable first, because Excel shows PivotTable-specific commands only when the PivotTable is selected. Make sure the workbook is open in the desktop version of Excel.
Switch the PivotTable Fields pane to the default areas layout
Use this option when the PivotTable Fields pane is visible but does not show the Filters, Columns, Rows, and Values areas.
The field-only layout hides the four placement areas. Switching to the first layout option restores the standard view, where you can drag fields into Filters, Columns, Rows, and Values.
Click any cell inside the PivotTable to activate the PivotTable Fields pane.
In the PivotTable Fields pane, click the gear icon or the layout/options button near the top of the pane.
Select the first layout option, typically the layout that shows the Fields section and the Areas section side by side or stacked.
Drag a field from the field list into Filters, Columns, Rows, or Values at the bottom of the pane.
Show the PivotTable Field List pane again
Use this option when the PivotTable Fields pane is completely hidden.
Manage PivotTable Fields and Areas in WPS Spreadsheet
WPS Spreadsheet provides familiar PivotTable tools for placing source fields into row, column, filter, and value areas. Select your PivotTable, open its field settings, and arrange fields with a straightforward drag-and-drop workflow.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, select Spreadsheets, and open the .xlsx or .xls workbook containing the PivotTable.
- 2. Select the PivotTable: Click any cell in the PivotTable to show the available PivotTable tools.
- 3. Open the field settings: Use the PivotTable tools or right-click the PivotTable to open the field list or field settings panel.
- 4. Place fields in the required areas: Drag available fields into the row, column, filter, or value section to change the PivotTable layout.
Frequently Asked Questions
Why are the Filters, Columns, Rows, and Values boxes missing in my PivotTable Fields pane?
The pane is usually set to a field-only layout. Click the gear or layout button in PivotTable Fields and select the first, default layout to restore the area boxes.
How do I reopen the PivotTable Fields pane in Excel?
Click inside the PivotTable, go to PivotTable Analyze on the ribbon, and select Field List in the Show group.
Where do I drag a field to make it a PivotTable filter?
After restoring the default pane layout, drag the field from the field list into the Filters area. Excel then adds a report filter above the PivotTable.
Can I add the same field to both Rows and Values in a PivotTable?
Yes. Drag the field into Rows, then drag it again into Values. Excel can group records by that field while also calculating a summary such as Count or Sum.
What if PivotTable Analyze does not appear on the ribbon?
Click a cell within the PivotTable rather than a normal worksheet cell. The PivotTable Analyze tab appears only when the PivotTable is selected.
