Microsoft Office Tutorials and References
In Depth Information
Creating a List from a Summary Table
4. Click Add.
5. Click OK to close the Excel Options dialog box.
After you perform these steps, your Quick Access toolbar displays a new icon.
Now it’s time to convert the summary table to a list. Keep in mind that, although the following
steps are specific to the sample data shown here, you can easily modify the steps to work with
your data. First, create the pivot table:
1. Activate any cell in your summary table.
2. Click the PivotTable and PivotChart Wizard icon, which you added to your Quick Access
toolbar.
3. In the PivotTable and PivotChart Wizard dialog box, select the Multiple Consolidation
Ranges option and click Next.
4. In Step 2a of the PivotTable and PivotChart Wizard dialog box, choose the I Will Create
the Page Fields option and click Next.
5. In Step 2b, specify a summary table range in the Range field (A1:E13 for the sample data)
and click Add; click Next to move on to Step 3.
6. In Step 3, select a location for the pivot table and click the Finish button.
Excel creates a pivot table from the data and displays the PivotTable Field list.
7. In the PivotTable Field List, deselect the check boxes from the fields named Row and
Column.
This leaves the pivot table with only a data field: Sum of Value.
At this point, a small pivot table shows only the sum of all values (see Figure 167-2).
Figure 167-2: This small pivot table can be expanded.
 
Search JabSto ::




Custom Search