ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I fix column widths in Excel Pivot Tables? (https://www.excelbanter.com/excel-discussion-misc-queries/1700-how-do-i-fix-column-widths-excel-pivot-tables.html)

skeezix December 10th 04 09:43 PM

How do I fix column widths in Excel Pivot Tables?
 
How do I fix column widths in Excel Pivot Tables so that width does not
change with each refresh?

terbstew December 11th 04 12:43 AM

If your pivot table is already created, select a cell within the table and
click on the Pivot Table Wizard Button. Select the Options button, deselect
the AutoFormat option box and select the Preserve Formatting option box.
If just creating your pivot table, at step 3 of 3 of the wizard click the
Options button and do as above.
Note: when formatting the table, if you have any categories in the "Page"
section, make sure it is set to "All" and not filtered otherwise it keeps the
original format set for each Page criteria. Took me a while to figure out
why it kept changing when I changed the criteria.


"skeezix" wrote:

How do I fix column widths in Excel Pivot Tables so that width does not
change with each refresh?



All times are GMT +1. The time now is 02:09 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com