Expand or collapse data details in Excel Services

If the workbook that you have contains a PivotTable report, you can expand or collapse to any level of data detail. For example, if you see data at a country/region level, you can expand to a state level, and down to a city level.

Note: Although the expand and collapse buttons are usually turned on by default, the workbook author may have turned off the expand and collapse buttons.

  • On a field, click the expand Expand button or collapse Collapse Button button.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!