Thread
:
how do I format a pivot table column - permanently?
View Single Post
#
3
Andy Brown
Posts: n/a
Is there any way to "lock" the formatting in a pivot table?
There's a way to "unlock" the standard formatting. Rightclick a cell of the
table, select "Wizard". Click "Options", *un*check "AutoFormat Table". Click
OK & Finish.
Rgds,
Andy
Reply With Quote