Row Labels
are Filters. The top row of the PivotTable is the Row Label: this is
the Field Header. You can use the Field Header to display
all of the products in the PivotTable or just a few if you wish.
8. Try
This: Filter the Data Click on the
Row Labels. Select: Edible
Fruit Select: Fruit
and Veggies. When you click
OK, the PivotTable will display those two products. Try This,
Too: Show All of the Data Click on the
Row Label: Select:
(Select All) Click OK.
Keep going...
What If You Don't See It?
The Field Headers can be turned on or off with the PivotTable
Tools. If you don't see the Field List please try this:
Go to PivotTable Tools ->Options.
Go to Show-> Field Headers.
Exam 77-888: Microsoft Excel Expert
2010
3. Presenting Data Visually
3.3. Apply and manipulate PivotTables:
Field Headers
PivotTable Tools ->Options-> Show> Field
Headers
|
|
| |
