Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell/column auto adjusts width to longest text string
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell/column auto adjusts width to longest text string
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell/column auto adjusts width to longest text string
What version of Excel are you using, that may be your issue, mine here is
2002 SP3 and it is just below width on the menu, the professor may have a version like mine if yours does not have it. -- -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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell/column auto adjusts width to longest text string
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
return cell address of longest text string in a range | Excel Discussion (Misc queries) | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
auto fit column width and row height | Excel Discussion (Misc queries) | |||
Longest string in a column | Excel Worksheet Functions | |||
fixed column width with text string | Excel Discussion (Misc queries) |