How to collapse and expand pivot table groups

Lets take a look.

Well turn off the buttons for now.

For example, we can expand and collapse each item in the category field individually, in any combination.

We can also expand and collapse the entire field at once.

Just select a cell in the field, and use the buttons on the ribbon.

These buttons are called Expand Entire Field, and Collapse Entire Field.

The same options are available in the right-click menu.

Use Expand Entire Field, and Collapse Entire Field under the Expand/Collapse menu.

We can use the same approach for column label fields.

If we select an item in the Year grouping, we can expand and collapse all quarters at once.

We can also work with each year individually by double-clicking.

We can, for example, add Region, and then expand and collapse region detail for each product.

Notice that Excel has added the Region field as a row label under product.

Of course, you’re free to remove fields added in this way at any time.