row height

  • Thread starter Thread starter Guest
  • Start date Start date
G

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???
 
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
Click to expand...
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???
 
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
 
Back
Top