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

Using AutoFormat

Although it may sound a bit trivial, formatting can be an important aspect of creating a pivot table report. Pivot tables make it very easy to produce reports that summarize data by three, four, five, or more fields. When you start to show this many fields on a two-dimensional piece of paper, the totals can get very busy. Besides giving your pivot table reports a professional look and feel, formatting can have an illuminating effect on reports that are convoluted by large amounts of data. The right formatting can make your pivot table reports easier to read and improve the clarity of your data.

One of the built-in tools Excel has to assist in formatting your reports is the AutoFormat function. Even if you never use AutoFormat in Excel, you should consider it with pivot tables. AutoFormat takes on a new importance with all the field names and subtotals in a pivot table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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