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?

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


Brock wrote:
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?

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
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Brock" wrote in message
...
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?

What if the columns in the row are merged?

"RagDyer" wrote:

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
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Brock" wrote in message
...
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?

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/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Tue, 5 Sep 2006 17:22:01 -0700, Brock
wrote:

What if the columns in the row are merged?

"RagDyer" wrote:

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
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Brock" wrote in message
...
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?