Automatic column width

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Opinicus - 18 Apr 2004 20:52 GMT

Is it possible? I have a spreadsheet with one column in it in which the
values may range between several thousand and several trillion. (These are
money values so scientific notation is not an option.) The values in that
column are all calculated on the basis of values in other columns' cells.
It's annoying to have to adjust the column width every time the number of
decimal places in the result change.

Signature

Bob
Kanyak's Doghouse
http://kanyak.com

Reply to this Message

Nick Hodge - 19 Apr 2004 00:19 GMT

Bob

Bear in mind Excel will only 'resolute' to 15 numbers and then will add
zeros unless you make it text and then you will not be able to calculate on
it.

To simply adjust the columns to the widest width hold your cursor to the
right of the column HEADER you wish to widen to the widest point and double
click. Excel will automatically size to the widest entry.

Highlight multiple columns (Click on the HEADERS and drag) and do the same
and all will 'autofit'

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

> Is it possible? I have a spreadsheet with one column in it in which the
> values may range between several thousand and several trillion. (These are
> money values so scientific notation is not an option.) The values in that
> column are all calculated on the basis of values in other columns' cells.
> It's annoying to have to adjust the column width every time the number of
> decimal places in the result change.

Reply to this Message

Phaedrusz - 19 Apr 2004 17:31 GMT

Hi Bob,

Another option is to highlight all (click on the upper left corner), o
just select the column you want to have adjusted, then go t
Format>Columns> and click on "autofit selection." The columns wil
automatically adjust. (You can do the same with Rows.)

Hope this helps

--
Message posted from http://www.ExcelForum.com

Reply to this Message