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! |
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! |
All times are GMT +1. The time now is 02:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com