Focusing and Hiding Pivoted Data

A straightforward way to refresh your view of a pivot table is to single out items for closer focus or to hide some of the pivot elements. This allows you to concentrate on particular items of interest.

Focusing redraws the pivot table to show only the item you have chosen to focus on.

The Show All Items command updates the pivot table to include all items removed by focusing. This command is available only when a pivot dimension label has been focused.

Hiding columns is a good way to temporarily suspend the display of a column.

To toggle the focus on a pivot item:

Select one or more dimension labels (either side or top).
Choose Focus on the shortcut menu.
The Pivot is redrawn to display only the chart object selected.

To show all items, select a dimensional label and choose Show All on the shortcut menu.

To hide pivoted data:

Select an item.
Select Hide Items on the shortcut menu.
The Pivot is redrawn to hide the selected object.

To restore a selected hidden item, select a pivot item and choose Show Hidden on the shortcut menu.