row height

[Guest]

how do I have an excel sheet which updates it's row height so that all text is shown. Auto height only makes it the height of one row of text - when the cell has wrapped text (muliple text), the rest of the text is hidden. Is there a way to make sure the heights always allow you to see the text???

 

[Frank Kabel]

Hi

Excel often has problems adjusting the row height
automatically in combination with wrpa text.AFAIK no way
around this then manually changinmg the height

-----Original Message-----
how do I have an excel sheet which updates it's row

height so that all text is shown. Auto height only makes
it the height of one row of text - when the cell has
wrapped text (muliple text), the rest of the text is
hidden. Is there a way to make sure the heights always
allow you to see the text???

 

[Gord Dibben]

Richard

Make sure Format>Row>Autofit is clicked.

If you are trying to wrap text on merged cells, Autofit won't work.

Merged cells will allow "wrap text" from Format>Cells>Alignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?threadm=e1$1uzL1BHA.1784@tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP