ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Locking column width - upon refresh of PivotTable (https://www.excelbanter.com/setting-up-configuration-excel/87413-locking-column-width-upon-refresh-pivottable.html)

pepenacho

Locking column width - upon refresh of PivotTable
 
Hello:

I have a PivotTable, which I use for a report. It contains a lot of data and
I'm trying to make it a bit bigger.

Each time I refresh, the column headings force the columns to widen-up
(where I previously wrapped the text to crunch the width of the column).

I'd hate to keep readjusting. Is there a way to set the width of the column
and row to a specific setting - permanently??

Thanks
Pepe


All times are GMT +1. The time now is 06:46 PM.

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