freeze column width in a pivot table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot tables and column widths 1
freeze width of a column used by pivot table 4
Save new column width settings in pivot table 5
Column width of Pivot Table data goes back to default when data refreshed 2
Pivot Table: Resulting Column Widths on Drill Down 0
column width in autoformatted pivot table 5
Pivot table column widths 1
Data display incomplete after creating Pivot Table 6

Back
Top