Auto Fit

  • Thread starter Thread starter Liz Anderson
  • Start date Start date
L

Liz Anderson

HELP! I want to auto fit columns based "not" on field name length but
on the longest data string within a specific column.

Issue:
I have created a pivot table and am able to succesfully drill down to
the underlying information. However, the drilled down s/s auto fits
the columns based on the field names and not the width of the longest
string within the column. I want to run some code to look at and
adjust all the columns based on the longest string within each column,
*not" the length of the field name. I also don't want to touch the
pivot table data field names. Any thoughts?

Ver. XL2K

TIA,
Liz
 
did you try selecting the cells in the column in the pivot table below the
field name and doing Format=>Column=>Autofit Selection
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

autofit with wrap 1
Giving a name to a row or column 2
Unable to Group in Pivot Table 1
Auto column fit 2
Pivot table drill down sort 0
How I can set dynamic pivot table ONLY when I have enough data point 1
Last Modified By in a cell by user 3
Select columns when drilling into a Pivot Table 1

Back
Top