Column Width Adjustment

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

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JerryA" <[email protected]> wrote in message
news:[email protected]...
> 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

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/

"JerryA" <[email protected]> wrote in message
news:[email protected]...
> 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

In article <[email protected]>, =?Utf-8?B?SmVycnlB?= <[email protected]> wrote:
>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)