Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
did you try selecting the cells in the column in the pivot table below the
field name and doing Format=Column=Autofit Selection -- Regards, Tom Ogilvy "Liz Anderson" wrote in message om... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 auto-recovery / auto-save? | Setting up and Configuration of Excel | |||
Auto Count for Auto Filter Doesn't Function under certain circumst | Excel Discussion (Misc queries) | |||
Auto-populate, Auto-copy or Auto-fill? | Excel Worksheet Functions | |||
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |