Microsoft Office Tutorials and References
In Depth Information
9. Select the Tuesday and Thursday check boxes, and then click OK .
Excel filters the PivotTable, summarizing only those values from Tuesdays and
Thursdays.
10. In cell A5, click the Hide Detail button.
Excel collapses rows that contain data from the year 2009, leaving only the subtotal
row that summarizes that year’s data.
11. In cell A5 , click the Show Detail button.
Excel redisplays the collapsed rows.
12. On the ribbon, click the Options contextual tab, and then, in the Show group, click
Field List .
The PivotTable Field List task pane opens.
13. In the PivotTable Field List task pane, click the Month field header arrow.
The filter menu opens.
Search JabSto ::




Custom Search