Pages

Saturday, March 3, 2012

pivot table contains several annoying items that you might want to change quickly

􀁑 The default table style uses no gridlines that makes it difficult to follow the rows and columns across.

􀀃 Numbers in the values area are in a general number format. There are no commas,currency symbols, and so on.

􀀃 For sparse data sets, there are many blanks in the values area. The blank cell in B16 indicates that there were no sales in Baltimore. Most people prefer to see zero instead of blanks.

􀀃 Excel renames fields in the values area with the unimaginative name Sum of Revenue.You can change this name

No comments:

Post a Comment