Collapse or Expand PivotTable Data to a Specific Level in Excel
Question details
The user wants to display an Excel PivotTable at a specific date or time level instead of showing minute-level detail.

- Product
- Microsoft Excel PivotTable
- Device & OS
- not provided
- Scenario
- A PivotTable contains grouped months, days, and timestamps, and the user wants a quicker way to review the data.
- Observed behavior
- The PivotTable expands down to the minute level, making the data difficult to review.
Click inside the PivotTable and identify the date or time field and the level you want to display. If the PivotTable Fields pane is hidden, open it from the PivotTable Analyze tab.
Collapse or expand the PivotTable to a chosen level
Use the PivotTable context menu to hide or reveal detail without changing the underlying data.
Right-click a month, day, or time item in the PivotTable row or column labels.
Select Expand/Collapse, then choose Expand To or Collapse To if available. In the dialog, select the level you want to display.
If you only need to hide the next level, right-click an item and choose Expand/Collapse > Collapse Entire Field. Use Expand Entire Field to show that detail again.

Adjust the date grouping and field placement
Use this approach when the PivotTable includes unwanted time intervals or its date fields are arranged in the wrong area.
Review PivotTable date levels in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and use the PivotTable expand and collapse controls to review date summaries without displaying every time entry.
- 1. Open the workbook: Launch WPS Spreadsheets and use Open to select the Excel workbook containing your PivotTable.
- 2. Find the date groups: Click the PivotTable and locate the month or day labels above the time details.
- 3. Collapse or expand a group: Click the minus button beside a date label to hide its detail, or click the plus button to show it again.
- 4. Save the workbook: Choose File > Save As to save your changes in the desired workbook format.

Frequently Asked Questions
How do I hide minute-level details without changing the grouping?
Right-click an item at the level above the minute details and choose Expand/Collapse > Collapse Entire Field. You can expand the field again when you need the detail.
Can I collapse just one month rather than the entire field?
Click the minus button beside that month in the PivotTable. Click its plus button later to expand it again.
Why should I check the Rows and Columns areas?
A date field in the wrong area can produce a layout different from the one you expect. Click the PivotTable, open PivotTable Analyze > Field List, and drag the field between Rows and Columns as needed.
What is the difference between grouping and collapsing dates?
Grouping sets intervals such as months or days through the right-click Group command. Collapsing hides lower-level details without removing those grouping levels.




