All the answers i see only changes the column width for an instant in time.
isn't there any way to have the coulmns continuasly change width as more data
is typed into them?

"William Horton" wrote:

Highlight the column and follow the Excel menu path Format / Column / Autofit
Selection.

You can also move your mouse just to the right of the column heading so that
it turns into a crosshair. Then double-click and the column will adjust to
the longest piece of data. Example, if you want to autofit column C you
would place your mouse in the column headings just between column C and D
until it turns into a crosshair (plus sign) and then double-click.

You can also use the wrap text property if you want text to wrap around
within a cell rather than widing the column.

Hope this helps.

Bill Horton

"Mariel" wrote:

I want to get the columns in the worksheet to fit the longest piece of data
in each cell. For instance, if I type a short word in a cell, and in the
cell beneath it, the word is longer, I want to learn a shortcut on how to get
the cell width to fit the data entered into it so the column will be adjusted
to show the longest word without wrapping. I have 10 columns and each one
has data from 2 letters to abut 40 letters. I know there is a way to get
each column to resize itself based on the longest text or numbers in them for
the whole sheet, but I've forgotten how. Any help will be greatly
appreciated.