ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Pivot Table Resizing (https://www.excelbanter.com/excel-programming/293782-pivot-table-resizing.html)

Todd huttenstine

Pivot Table Resizing
 
Good morning!!!

I have been working with pivot tables lately and now that
I am finally almost done I would like to stop the
automatic resizing of the pivot tables when I select a
value from one of the pivot table drop downs and I dont
know how. I have a title above the pivot table and when
it automatically resizes when I select a value, it
shortens the width of the column and you cant see the
entire title. Is there a way to stop this resizing or a
place I can go to specifiy the minimal width of the column?


Thank you

Todd Huttenstine

Todd huttenstine

Pivot Table Resizing
 
Well I found it. Its under Table options/auto format
option.

Todd
-----Original Message-----
Good morning!!!

I have been working with pivot tables lately and now that
I am finally almost done I would like to stop the
automatic resizing of the pivot tables when I select a
value from one of the pivot table drop downs and I dont
know how. I have a title above the pivot table and when
it automatically resizes when I select a value, it
shortens the width of the column and you cant see the
entire title. Is there a way to stop this resizing or a
place I can go to specifiy the minimal width of the

column?


Thank you

Todd Huttenstine
.



All times are GMT +1. The time now is 07:24 PM.

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