How can I set the row height to adjust to fit wrapped text

  • Thread starter Thread starter chasinamie
  • Start date Start date
C

chasinamie

When I have set the text to wrap in a cell, I would like for the row height
to adjust automatically to show all of the text in the cell
 
What happens when you try autofitting the rowheight--either by doubleclicking on
the separator on the row indicators or via the format|row|autofit (xl2003
menus)?
 
Format>Row>AutoFit.

Note: won't work if you are using merged cells.

You need event code to autofit in that case

Also.............you can enter 32767 characters in a cell but only 1024 of
these will display no matter the height.

If this is your problem, add a linefeed every 100 chars using Alt + Enter.


Gord Dibben MS Excel MVP
 
Gord,
how do we get to Format>row>automatic when using Micorsoft - Office - Excel
- 2007? I know it in 2003 but with the modifications applied to 2007 I
have lost it.
Thanks
Larry_o
 
Back
Top