- Wrap Text Does Not Adjust Row Height In Excel 2011 For Mac Download
- How To Change Row Height In Excel
- Wrap Text Does Not Adjust Row Height In Excel 2011 For Mac
Related Articles
- 1 Make a Two Column Spread Sheet on Microsoft Excel
- 2 Make the Adjusted Column Spacing Even in Excel
- 3 Insert a Caret in Excel
- 4 Add a Border by Clicking in Excel
Microsoft Excel spreadsheets help you make quick work of sales figures, project costing and other on the heading for the last row in the series. Alternatively, click and drag through the range of headings to make a multirow selection.
The formula returns text and depending on what is entered as data, it can be a short text or a longer one (the cell is also merged and wrap text is on). Excel does not alter the row height according to the returned text. Adjust the row height to make all wrapped text visible Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, click Format.
2.Click on the 'Format' item in the Home tab's Cells group. In the Cell Size section of the drop-down menu that opens, click on 'Row Height.'
3.Type the desired size into the 'Row Height' field of the Row Height dialog box. Click the 'OK' button to apply your changes.
Tips
- By default, Microsoft Excel automatically resizes row heights to the size of the largest type contained in any cell within the row. To apply this AutoFit process manually, click on the 'Format' item in the Home tab's Cells group and choose 'AutoFit Row Height.'
- To resize multiple rows with your pointing device, drag the bottom edge of the row heading on any row in a multirow selection. Note that only the heading heights change until you release your pointing device.
- You can right-click on a selection to access the Row Height dialog box.
Warnings
- Rows with merged cells do not respond to the AutoFit command.
- Information in this article applies to Microsoft Excel 2013. It may differ slightly or significantly with other versions or products.
References (3)
Resources (1)
About the Author
Elizabeth Mott has been a writer since 1983. Mott has extensive experience writing advertising copy for everything from kitchen appliances and financial services to education and tourism. She holds a Bachelor of Arts and Master of Arts in English from Indiana State University.
Cite this ArticleChoose Citation Style
So, today is my bad day
I discovered that excel row AutoFit - doesn't work
Chr(10) instead of vbNewLine - doesn't help
It works only if I write without line breaks:
Wrap Text Does Not Adjust Row Height In Excel 2011 For Mac Download
AlegroAlegro5 Answers
Make sure that the cells that have line breaks in them have 'Wrap Text' turned on. You can turn it on with VBA like so:
JosephJosephAutofit doesn't work on merged cells. My guess is that's what you are trying to do.
Work around this by simulating the autofit on a single cell with the same width as your merged cell and set the height it gives you.
Something like this:
I solved an issue with this - I had a row with two merged cells both containing multi-line text with Chr(10) linefeeds - with Wrap set ON (but no lines actually wrap - only the Chr(10)s cause new lines). Autofit wouldn't work due to the merged cells.
The VBA workaround was to use a spare cell on the same row, and fill it with the same number of Chr(10) as found in one (either) of the multi-line cells. Then call AutoFit for that cell now containing the same number of invisible line feeds. Make sure the font and size are the same in the spare cell!
An alternative method for other scenarios could be to use an extra, hidden, worksheet - set a single cell to the same column width as your merged cells, copy the contents over, call autofit (which should work on the unmerged cell), then use the resulting rowheight from that one.
AjV JsyAjV JsyOne workaround is to shrink the column width down a bit for the column(s) that are causing the autofit problem, select all the rows you want to change, autofit the row height by double-clicking one of the row separators, and finally autofit the column(s) from the first step by double-clicking the column separator(s). Probably works best if only one or just a few columns consistently have the most text in their cells.