LesterRadford
asked on
Wrap Text in Excel
I wish to have a row automatically extend once I complete typing text into a cell in an excel spread sheet (Office 2010) where the cell has been formatted as wrap text. My master spread sheet on the project I am working on used to do this but somehow this has stopped happening. Suggestions welcome.
LCR
LCR
Please clarify what you mean by 'row automatically expand' ?
ASKER
After entering text I press the enter key. I am now finding the cell does not expand automatically. Of course if a cell expands the so does the line the text is on.
I've never seen that behaviour, autofit column width (in excel 2013) only works after the cell data is entered and you choose autofit from the Cells, format, autofit column or hover over the line marking the right hand side of the column and double click.
if you are entering data into the final column and nothing has ever been entered in the column to the right of it then the text will extend over subsequent columns until you enter something there - could that be what you remember seeing?
It may be that earlier versions handled it differently
if you are entering data into the final column and nothing has ever been entered in the column to the right of it then the text will extend over subsequent columns until you enter something there - could that be what you remember seeing?
It may be that earlier versions handled it differently
ASKER
Hi, My last comment should have said;
After entering text I press the enter key. I am now finding the cell does not expand automatically. Of course if a cell expands the so does the ROW the text is on.
I am not expecting the column to expand only the row.
After entering text I press the enter key. I am now finding the cell does not expand automatically. Of course if a cell expands the so does the ROW the text is on.
I am not expecting the column to expand only the row.
I can only suggest that the data used to be formatted as a table and its either been converted back to a range or the 'automatically add columns' option has been disabled - this can happen if the tool tip is accidentaly activated. It can be turned back on in file, options, proofing, autocorrect, auto format as you type, include new rows and columns in the table
if its been converted to a range you will need to select all of it and 'insert table'
If none if this makes sense/solves the problem can you post a copy of the sheet and highlight what you mean?
if its been converted to a range you will need to select all of it and 'insert table'
If none if this makes sense/solves the problem can you post a copy of the sheet and highlight what you mean?
Just to clarify a little bit more. You want a wrapped text , that is becoming longer, than when it was originally created to automatically expand, so it will always show the full text in the cell?
ASKER
Yes to Jorgen's question
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hi Jorgen,
I understand what is happening now. Thanks for your answers. Most appreciated.
I understand what is happening now. Thanks for your answers. Most appreciated.
ASKER
No more comments. Just good to identify what the issue is. Again, many thanks. LCR