Format pivot table / column width

M

mcarter

How do I keep the column width the same after I select a new value in a pivot
table? after I select a new value to filter the data, it changes the column
widths and I have to change them back every time i select a new value to
filter.
 
T

Teethless mama

Highlight Pivot Table > right click > select Table Options > tick on Preserve
formatting > OK out
 
M

mcarter

I have the preserve formatting on...

Teethless mama said:
Highlight Pivot Table > right click > select Table Options > tick on Preserve
formatting > OK out
Click to expand...
 

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

Lock Pivot Table Column Width 2
Column width of Pivot Table data goes back to default when data refreshed 2
Access #Error & Excel Pivot 0
Pivot tables and column widths 1
Pivot table Help Excel 2007 1
pivot table 1
Returning a label rather than a number in pivot table field 1
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0

Top