column width in autoformatted pivot table

U

user3307

i have chosen an autoformat for my pivot table, but would like to change the
column width (also after refreshing).
is this possible?

thanks.
e.
 
B

Bernie Deitrick

From 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, then click OK


HTH,
Bernie
MS Excel MVP
 
U

user3307

thank you for your kind reply.
this however removes all the formatting of the table, which is what i would
like to avoid.
i guess it is not possible to customise an autoformat then?

e.
 
B

Bernie Deitrick

e.,

Another option is recording a macro where you set the column widths, and then run the macro after
the table refresh.

HTH,
Bernie
MS Excel MVP
 
U

user3307

good idea, thanks.

Bernie Deitrick said:
e.,

Another option is recording a macro where you set the column widths, and then run the macro after
the table refresh.

HTH,
Bernie
MS Excel MVP
Click to expand...
 
J

Jim Thomlinson

Another option is to insert a blank row above your pivot table and add
characters to the cells to achieve the correct column width when the column
is autofit. Since auto format autofits the columns you will ned up with the
correct spacing...
 

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
Pivot Table refresh 3
Column width of Pivot Table data goes back to default when data refreshed 2
Save new column width settings in pivot table 5
Pivot Table format changes when data is refreshed 8
pivot tables changing their formats when data is refreshed 1
Typing Over Pivot Table Rows and Columns 1
Pivot table column widths 1

Top