Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

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

Formatting PivotTables

PivotTables are the ideal tools for summarizing and examining large data tables, even those containing in excess of 10 or even 100,000 rows. Even though PivotTables often end up as compact summaries, you should do everything you can to make your data more comprehensible. One way to improve your data’s readability is to apply a number format to the PivotTable Values field. To apply a number format to a field, right-click any cell in the field and then click Number Format to display the Format Cells dialog box. Select or define the format you want to apply and then click OK to enact the change.

See Also

For more information on selecting and defining cell formats by using the Format Cells dialog box, see "Formatting Cells" in Chapter 5.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint