PivotTable: Field Headers

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