Wrapping Text and Cell Expansion

[Guest]

When a cell is formatted to wrap text and the text takes up more than a
single row how do I get the row to automatically expand vertically to
accomodate the text?

 

[stevebriz]

this is only way as far as I know without some macros

Select the row or rows that you want to change.
Point to Row on the Format menu, and then click AutoFit.

Tip: To autofit all rows on the worksheet, click the Select All
button and then double-click the boundary below one of the row
headings. Or select all rows, point to Row on the Format menu, and then
click AutoFit.
HTH

 

[RagDyer]

First of all, make sure the cell is not 'merged'.

Next, if you, at any time, manually adjusted the height of the row,
"auto-fit" becomes disabled.

To re-set it to automatic, try:
<Format> <Row> <Auto-Fit>

 

[Guest]

What if the columns in the row are merged?

First of all, make sure the cell is not 'merged'.

Next, if you, at any time, manually adjusted the height of the row,
"auto-fit" becomes disabled.

To re-set it to automatic, try:
<Format> <Row> <Auto-Fit>

 

[Gord Dibben]

If cells are merged. the row will not autofit without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micr...60cbeb27874?lnk=st&q=&rnum=4#ca1c160cbeb27874


Gord Dibben MS Excel MVP