Microsoft Office Tutorials and References
In Depth Information
Filtering, showing, and hiding PivotTable data
10
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.
11
In cell A5 , click the Show Detail button to redisplay the collapsed rows.
12
If the PivotTable Fields pane isn’t displayed, click the Analyze tool tab, click Show ,
and then click Field List .
13
In the PivotTable Fields pane, click the Month field header arrow to open the filter
menu.
14
In the Search box, enter Ju . Excel displays the months June and July in the filter list.
Search JabSto ::




Custom Search