Column Width Adjustment

[Guest]

Is there a way to adjust the column width automatically to fit the length of
the longest data in the cell. I know how to do it one column at a time but
not how to do all columns of data at once.

Thanks,

Jerry

 

[Ragdyer]

Do a <Ctrl> <A>
to select the entire sheet, then,
Do the same thing you would do for a single Column:
<Format> <Column> <AutoFit>

 

[Martin Rice]

Jerry

In a macro use

Columns.AutoFit

Without a macro, select all cells (the interection of row and column
headings) and double click on any one column junction.

Martin

--
~~~~~~~~~~~~~~~~~~~~~~~~~~~
Visit Eighty-Twenty Spreadsheet Automation for professional customised
spreadsheet development

http://homepage.ntlworld.com/martin.rice1/

 

[Bruce Sinclair]

Is there a way to adjust the column width automatically to fit the length of
the longest data in the cell. I know how to do it one column at a time but
not how to do all columns of data at once.

Select all the columns you want to do this with and double click on the
right side of the column header. Done.


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)