How to Keep the Excel PivotTable Fields Pane Open
Question details
The user wants to prevent the Excel PivotTable Fields pane from collapsing after selecting a single field, to easily add multiple fields from an attached database.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Adding multiple fields from an attached database source into an Excel PivotTable.
- Observed behavior
- The PivotTable Fields folder or pane automatically collapses after a field is selected, interrupting the workflow and requiring the user to expand it repeatedly.
Ensure your cursor is placed inside the PivotTable to make the Fields pane visible. If choosing to apply the VBA method, save a backup copy of your Excel workbook first.
Use Interface Workarounds for PivotTable Fields
Since Excel lacks a direct setting to prevent the fields folder from collapsing, adjusting the pane layout and using drag-and-drop are the most practical workarounds.
Excel does not currently offer a built-in toggle to keep the folder expanded after every selection. Adjusting how you interact with the Fields pane can help minimize the inconvenience.
Click the gear icon (Tools) in the top-right corner of the PivotTable Fields pane to adjust its layout. Drag the edges of the pane to enlarge it, giving you a wider view of your available fields.
Instead of manually navigating through collapsing folders, type the specific field name into the search box located at the top of the PivotTable Fields pane to instantly locate and select it.
Rather than checking the boxes (which triggers the collapse), click and hold a field, then drag it directly into the Rows, Columns, or Values areas. Repeat this for multiple fields and rearrange them in the bottom sections once added.

Add Multiple Fields Programmatically via VBA
Use a VBA macro to instantly add a specific set of fields to your PivotTable without manually interacting with the collapsing pane.
Experience Smoother Data Analysis with WPS Office
If Excel's interface limitations are slowing down your data reporting, try WPS Office. It provides a free, highly compatible, and user-friendly Spreadsheet alternative that processes complex data and PivotTables seamlessly.
- 1. Download WPS Office: Visit the official WPS Office website to download and install the free software suite.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file containing the database connection.
- 3. Manage Data Smoothly: Click inside your PivotTable to access the user-friendly field list and manage your data without interruptions.

Frequently Asked Questions
Can I completely stop the PivotTable Fields pane from auto-hiding?
By default, clicking outside the PivotTable will hide the Fields pane. To bring it back, simply click any cell inside the PivotTable. If you closed it via the 'X' button, you must reopen it manually by going to 'PivotTable Analyze' > 'Field List' on the ribbon.
Why does my PivotTable field folder collapse automatically?
This is a default software behavior in Excel, particularly common when connecting to OLAP cubes or certain external databases. Excel collapses the hierarchy after a selection to save visual space, but unfortunately, there is no setting to disable this.
How do I quickly add multiple fields to a PivotTable?
To bypass interface glitches, you can select multiple fields in the field list and drag them manually into the Rows, Columns, or Values areas. Alternatively, use a customized VBA script to instantly assign multiple fields at once.
Is there a shortcut to toggle the PivotTable Field List?
Yes, you can quickly show or hide the PivotTable Field List by right-clicking any cell within your PivotTable and selecting 'Show Field List' or 'Hide Field List' from the context menu.




