Leading the way in Microsoft Office Development
 Home|

Excel

|Word|PowerPoint|Consultancy|Feedback|Contact 
 Excel > Pivot Tables > Pivot Table Styles< Previous | Next > 

 

What is a Pivot Table Style ?

 

 

PivotTable Styles have the same design goals as Table Styles, and they also have the same user model and customization story.

 
 

The only real difference between the PivotTable and Table Styles is with regards to the number of elements in a PivotTable style.

 
 

Whereas Table Styles have 13 elements (headers, row banding, total rows, etc.), PivotTable styles have 25 elements.

 
 

The additional elements are due to the fact that PivotTables are more complex than tables, so there are more table elements available for users to define formatting on.

 
 

For example, you can define formatting for multiple levels of data, there are multiple levels of subtotals possible in a PivotTable, etc.

 

 

Excel 12 will come with a large set of predefined PivotTable styles that you can pick and choose from.

 
 

In addition, just like table styles, you can create your own styles that fit your specific needs whether that might be corporate guidelines or individual preferences.

 
 

PivotTables, however, are more complex than tables, so there are more table elements available for users to define formatting on.

 
 

For example, you can define formatting for multiple levels of subtotals, you can define striping at different levels in the PivotTable.

 








 Copyright © 2010 Better Solutions Limited. All Rights Reserved.< Previous | Top | Next >