Microsoft Office Tutorials and References
In Depth Information
Organizing Lists in Pivot Tables
You can also drag headings from the Row Labels box to the Column
Labels box and vice versa.
Filtering a pivot table
The more information your pivot table contains, the harder it can be to make
sense of any of the data. To help you out, Excel lets you filter your data to
view only certain information, such as sales made by each salesperson or
total sales within a region. To filter a pivot table, follow these steps:
1. Click the pivot table you want to filter.
The PivotTable Field List pane appears.
2. Click a heading in the Row Labels or Column Labels group in the
PivotTable Field List pane.
A pop-up menu appears.
3. Click Move to Report Filter.
Excel moves your chosen label into the Report Filter group in the
PivotTable Field List pane, as shown in Figure 10-20.
Figure 10-20:
A filtered
pivot table
displays
only the
information
you want to
see, such
as only
sales results
for each
salesperson
regardless
of the
product
sold.
 
Search JabSto ::




Custom Search