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

chasinamie wrote:

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

--

Dave Peterson

FormatRowAutoFit.

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


On Thu, 2 Oct 2008 08:46:00 -0700, chasinamie
wrote:

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

Gord,
how do we get to Formatrowautomatic 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

"Gord Dibben" wrote:

FormatRowAutoFit.

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


On Thu, 2 Oct 2008 08:46:00 -0700, chasinamie
wrote:

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

I don't use 2007 but I think..........FormatRowHomeCells

See Ron de Bruin's site for where to find the 2007 Commands

http://www.rondebruin.nl/0307commands.htm


Gord

On Wed, 29 Oct 2008 10:16:07 -0700, Larry_o
wrote:

Gord,
how do we get to Formatrowautomatic 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

"Gord Dibben" wrote:

FormatRowAutoFit.

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


On Thu, 2 Oct 2008 08:46:00 -0700, chasinamie
wrote:

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