Wrapping Text and Cell Expansion

B

Brock

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?
 
S

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
 
R

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>
 
B

Brock

What if the columns in the row are merged?

RagDyer said:
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>
Click to expand...
 
Top