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

Formatting PivotTables

New to Excel 97, PivotTables now support persistent formatting. This feature lets you format a PivotTable, and your formatting is maintained even after you change the PivotTable. Previously, you had to manually reformat the PivotTable every time you changed it.

In order for persistent formatting to work, the Preserve Formatting option must be selected in the PivotTable Options dialog box (refer to Figure 20.25 and Table 20.3).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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