Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
In cell A5 , click the Hide Detail button. Excel collapses rows that contain data from
the year 2012, leaving only the subtotal row that summarizes that year’s data.
In cell A5 , click the Show Detail button to redisplay the collapsed rows.
If the PivotTable Fields pane isn’t displayed, click the Analyze tool tab, click Show ,
and then click Field List .
In the PivotTable Fields pane, click the Month field header arrow to open the filter
In the Search box, enter Ju . Excel displays the months June and July in the filter list.