Microsoft Office Tutorials and References
In Depth Information
For example, you might have your data divided by year; clicking the Show Detail control
next to the 2009 year header would display that year’s details. Conversely, clicking the
2010 year header’s Hide Detail control would hide the individual months’ values and
display only the year’s total.
Excel 2010 provides two new ways for you to filter PivotTables: search filters and Slicers.
With a search filter, you can type in a series of characters for Excel to filter that field’s
values. To create a search filter, click a field’s filter arrow and type the character string
for which you want to search in the filter menu’s Search box.