Solved

Wrap Text in Excel

Posted on 2014-02-19
10
479 Views
Last Modified: 2014-02-20
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
0
Comment
Question by:LesterRadford
  • 5
  • 3
  • 2
10 Comments
 
LVL 19

Expert Comment

by:regmigrant
ID: 39871905
Please clarify what you mean by 'row automatically expand' ?
0
 

Author Comment

by:LesterRadford
ID: 39871959
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.
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39871985
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
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 

Author Comment

by:LesterRadford
ID: 39871998
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.
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39872027
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?
0
 
LVL 4

Expert Comment

by:Jorgen
ID: 39872756
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?
0
 

Author Comment

by:LesterRadford
ID: 39872933
Yes to Jorgen's question
0
 
LVL 4

Accepted Solution

by:
Jorgen earned 500 total points
ID: 39872988
Hi again, There is a kb article on this which "suggests" (it's unacceptably sparse, in classic Microsoft fashion) that if you ever set a row height, automatic height autofitting is permanently gone for that row of that worksheet. Rows whose height you haven't touched will autofit fine though. And in Excel 2010, you cannot use the AutoFit feature for rows or columns that contain merged cells in Excel.

If you are into VBA, you can put this procedure into your worksheet.activate event, then you

Declare the variables x and lngLastRow and set lngLastRow and insert the code below, where A is the column, you want to autofit.

For x = 1 To lngLastRow + 10
    Range("A" & x).EntireRow.AutoFit
Next x

I hope that is clear, otherwise get back to me.

best regards

Jørgen
0
 

Author Comment

by:LesterRadford
ID: 39874980
Hi Jorgen,
I understand what is happening now. Thanks for your answers. Most appreciated.
0
 

Author Closing Comment

by:LesterRadford
ID: 39874990
No more comments. Just good to identify what the issue is. Again, many thanks. LCR
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VBA to apply same filter values to multiple tables in Excel 6 33
Alphabetical Order for Letters 2 21
Excel Spacing Anomaly 4 23
VBA Works in Excel 2010 Not 2016 Help! 5 18
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question