freeze column width in a pivot table

M

Martha Navarro

I am preparing an important document and I need to be able to "freeze the
column width in a pivot table, so that when I enter more information the
column won't change and show: ####### instead of an amount.

thank you
 
E

Excelenator

All you need to do is select the pivot table column (hover over th
field name until the black arrow shows up) and then left click t
select the entire column of data. Once this is done you can set you
column width for that column and when you refresh your data the colum
width won't change
 
D

Debra Dalgleish

Right-click a cell in the pivot table, and choose Table Options
Ensure that Preserve Formatting is turned on, and AutoFormat is turned off.
Click OK
 
Top