Nevermind, i see what you are saying now, sorry for the confusion, I do not
know of another way without code
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"redsanders" wrote:

Thanks John - but there is no "Auto-Width". There is "Autofit" which works
after the fact - that is one is adjusting the column after the text is
entered - of which I am aware of a number of ways - i.e. double click the
line dividing columns. What the instructors said is possible is for Excel to
"real time" adjust the colum as one enters text.

"John Bundy" wrote:

Select the columns and then in the menu Format-Columns-Auto-Width
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"redsanders" wrote:

Is it possible to have Excel automatically extend the width of a column as
text is entered. That is, instead of the text spilling over into the
adjoining cell, the column automatically increases in width. Answer needed
for one of our teachers ASAP - college instructor claims it can be done - I
am unable to find it anywhere.