Lesson 58: Pivot Table Data

Data of an item in detail

A “Pivot table” is a summary of data. By clicking on the ” + / -Buttons” in the “Options” tab of the “PivotTable Tools”, we can place “+” and “-” characters for the fields in the “Row Labels” area.

Click on these characters, we can view or hide the details of a field.

A second way to view details of these fields is by clicking on the “Expand Entire Field” button and “Collapse Entire Field” button in the “Options” tab.

This unfolds the details of all the fields.

If you wish to unfold the data from one field only, double click that field.

Another way to view the details of fields is to right-click on the field, and select “Expand and collapse.”

In the submenu that appears, we have a choice of options which are quite clear.

Data from a cell in detail

Every cell in our “PivotTable” is a summary of several rows from a database or table.
To see the details of a cell in our PivotTable, we double click this cell.
This gives every detail in a new worksheet from which this cell is formatted.

If you do not need this information later, you can delete the new worksheet.
Right click the new worksheet and select “Delete”.

You can disable this option by selecting the “Options” tab in the “Ribbon”, and click the “Options” button.
This opens the “Options” dialog.
In the “Data” tab uncheck the box for the text “Enable Show details”.
And click OK.

Awesome!
You've completed Lesson 58 START NEXT LESSON

Lesson 58

Office 2007 - Excel