1-866-245-5224 sales@keystonelearning.com

Excel 2003: Modifying a PivotTable

Excel 2003: Modifying a PivotTable

When we talk about modifying a PivotTable, there’s actually a whole host of things that we can do to change an existing PivotTable. In this lesson, we’re just going to look at a few of those options to give you an idea of the flexibility and power of this feature.

Sorting Data in Column or Row Labels

     
  1. Select a column or row field label in a PivotTable report
     
  2.  
  3. Choose Sort Z to Z or Sort Z to A on the Standard toolbar
     

Formatting Cells

     
  1. Select a column or row field label in a PivotTable report
     
  2.  
  3. Right-click and choose Format Cells… from the Shortcut menu
     
  4.  
  5. Set the formatting in the Format Cells Dialog box
     
  6.  
  7. Click OK
     

Removing a Field from a PivotTable

     
  1.  Open the Field List Task Pane
     
  2.  
  3. Drag the field name you want to remove outside the PivotTable
     

Formatting the PivotTable

     
  1. Select a column or row field label in a PivotTable report
     
  2.  
  3.  Click the Format Report button on the PivotTable toolbar
     

Figure 37. PivotTable AutoFormat Dialog Box