• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Setting PivotTable Options

Clicking the Options button in the Step 3 of 3 dialog box for the PivotTable Wizard opens the PivotTable Options dialog box, in which you can further specify formats and data source options (see Figure 20.19). You can access this dialog box after completing the wizard by either clicking the PivotTable button on the PivotTable toolbar and selecting Table Options from the drop-down list, or by right-clicking a completed PivotTable and selecting Table Options from the context menu.

Figure 20.19. You can customize the PivotTable format and data options.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint