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

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
 
D

Dave Peterson

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)?
 
G

Gord Dibben

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
 
L

Larry_o

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top