ExcelBanter - Pivot Tables Auto Format Change

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Pivot Tables Auto Format Change (https://www.excelbanter.com/excel-worksheet-functions/184892-pivot-tables-auto-format-change.html)

Eva

Pivot Tables Auto Format Change

Hi
I would like to apply my own auto format to my pivot tables.
How to do it?

Thank you in advance
Eva

Debra Dalgleish

Pivot Tables Auto Format Change

You can't create your own AutoFormats for pivot tables. You can manually
format the the pivot table, by selecting sections and using the
formatting commands.

In Excel 2007, there are pivot table styles, and you're able to create
some of your own.

Eva wrote:
Hi
I would like to apply my own auto format to my pivot tables.
How to do it?

Thank you in advance
Eva

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Eva

Pivot Tables Auto Format Change

Thanks

"Debra Dalgleish" wrote:

You can't create your own AutoFormats for pivot tables. You can manually
format the the pivot table, by selecting sections and using the
formatting commands.

In Excel 2007, there are pivot table styles, and you're able to create
some of your own.

Eva wrote:
Hi
I would like to apply my own auto format to my pivot tables.
How to do it?

Thank you in advance
Eva

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 08:29 PM.