#1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Auto Fit

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Auto Fit

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 auto-recovery / auto-save? gpurdue Setting up and Configuration of Excel 0 May 23rd 08 10:19 PM
Auto Count for Auto Filter Doesn't Function under certain circumst Jonathan Horvath Excel Discussion (Misc queries) 2 August 17th 07 03:51 AM
Auto-populate, Auto-copy or Auto-fill? Jay S. Excel Worksheet Functions 4 August 10th 07 09:04 PM
How to AUTO SAVE as opposed to turning on auto recovery: EXCEL T-mo Excel Discussion (Misc queries) 1 January 12th 06 10:16 PM
excel links update not working in auto, calculations in auto Mikey Boy Excel Worksheet Functions 0 December 7th 04 11:53 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"