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

Setting Table Options

Beyond the formatting of colors and fonts within your pivot table report, you can tweak 13 format options to modify the way your pivot data is presented and printed. These options are found in the PivotTable Options dialog box. If you regularly set these options, you can access step 3 of the PivotTable Wizard by choosing the Options button in the lower left of the dialog box.

After creating a pivot table, you can activate the PivotTable Options dialog box by right-clicking inside your pivot table and selecting Table Options. Alternatively, the pivot table drop-down on the left side of the pivot table toolbar includes a Table Options selection near the bottom.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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