Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables and column widths
Is there a way to permanently reset the column widths in a pivot tables? I
am able to change the column width, but it defaults back to a standard width each time I refresh the pivot table. Can I set it up so that it will stay at a width defined by me? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot tables and column widths
In EXCEL 2007 try this:-
1. Right click the Pivot Table / PivotTable Options . . . / Layout & Format tab / remove the tick from:- Autofit column widths on update OK If my comments have helped please hit Yes. Thanks "Krissy" wrote: Is there a way to permanently reset the column widths in a pivot tables? I am able to change the column width, but it defaults back to a standard width each time I refresh the pivot table. Can I set it up so that it will stay at a width defined by me? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table column widths | Excel Discussion (Misc queries) | |||
Pivot table column widths | Excel Discussion (Misc queries) | |||
Pivot Table Column Widths | Excel Worksheet Functions | |||
Pivot table column widths | Excel Discussion (Misc queries) | |||
How do I fix column widths in Excel Pivot Tables? | Excel Discussion (Misc queries) |