up vote 0 down vote favorite
share [g+] share [fb]

I have a cell with wrapped text content in Excel and I want to format the cell so that its height will adjust to fit the content which can span over several lines. How can I achieve this behavior?

link|improve this question
70% accept rate
not sure about excel 2007, but I am using excel 2003 and there that goes automatically, when I input multi-line data in a cell, the line height gets fixed when I press enter. – fretje Aug 25 '09 at 8:57
feedback

4 Answers

up vote 2 down vote

If it doesn't automatically do it, then place your cursor over the small line between row numbers (ex: between 1 and 2) and double click, this will resize the row (directly above the small line, in the example: 1) so that everything is visible (from a vertical aspect).

link|improve this answer
feedback
up vote 0 down vote

Try

Select the column -> right-click column -> Format Cells -> Alignment tab -> Wrap text

link|improve this answer
The cell already has this formatting and I want the cell to also adjust its height. I want the height of the cell's row to adjust so that the whole wrapped content of the cell is visible. – Manga Lee Aug 25 '09 at 9:21
2  
I'm not sure if you can make this happen as the contents of the cell change, but once your finished double clicking on the border between the row number and the one below auto sizes it to fit the contents. – Col Aug 25 '09 at 10:12
+1: This is not a bad answer. If you toggle Wrap Text off and on again, Excel will resize the row height to fit the tallest row. Not suitable if the height of rows is changing dynamically but if you're dealing with static text it should be OK. – Li-aung Yip Mar 2 at 2:21
feedback
up vote 0 down vote

Do you know macro? Put the following code in

Application.ActiveCell.WrapText = True

inside your Worksheet_SelectionChange subroutine.

link|improve this answer
feedback
up vote 0 down vote

Call Application.ActiveCell.AutoFit

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.