Cell/column auto adjusts width to longest text string
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.
|