ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table: Resulting Column Widths on Drill Down (https://www.excelbanter.com/excel-discussion-misc-queries/181347-pivot-table-resulting-column-widths-drill-down.html)

EarlyBirdie

Pivot Table: Resulting Column Widths on Drill Down
 
How can I automatically set the column widths on the spreadsheet that the
system displays when I doulble click on a cell in a pivot table in order to
look at the detail? Currently when I do that, one of the columns that
contains a large amount of text data is being wrapped (which is what I want)
but in a very narrow cell resulting in a very large row height. I don't want
to have to adjust these column widths and then row height each time I "drill
down" from the pivot table.

--
EarlyBirdie


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

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