ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   designing and saving predefined pivot table formats? (https://www.excelbanter.com/excel-worksheet-functions/19175-designing-saving-predefined-pivot-table-formats.html)

Surfstiling

designing and saving predefined pivot table formats?
 
Is there a way to design user specific pivot table layouts? Can you save
those in the pull down menu?

Debra Dalgleish

You can't add to the built-in list of AutoFormats.

You can create Styles, or record a macro as you apply formatting.


Surfstiling wrote:
Is there a way to design user specific pivot table layouts? Can you save
those in the pull down menu?



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 11:58 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com