Cells A1:C1 are merged with wrap text. I have entered six lines of text and
row height automatically adjusted because I have the macro running to do this.

Cells D1:G1 are merged with wrpa text. I enter three lines of text and row
height automatically adjusts for this cell only hiding three lines of text in
A1:C1. How do I get to see all six lines?

Thanks,

Gary

You have a suggestion at your other post.

gwinder wrote:

Cells A1:C1 are merged with wrap text. I have entered six lines of text and
row height automatically adjusted because I have the macro running to do this.

Cells D1:G1 are merged with wrpa text. I enter three lines of text and row
height automatically adjusts for this cell only hiding three lines of text in
A1:C1. How do I get to see all six lines?

Thanks,

Gary


--

Dave Peterson

If cells are merged. the row will not autofit even with wrap text enabled
without using VBA

See google search thread for code by Greg Wilson

http://groups.google.com/group/micro...1c160cbeb27874


Gord Dibben MS Excel MVP

On Thu, 14 Dec 2006 02:39:00 -0800, gwinder
wrote:

Cells A1:C1 are merged with wrap text. I have entered six lines of text and
row height automatically adjusted because I have the macro running to do this.

Cells D1:G1 are merged with wrpa text. I enter three lines of text and row
height automatically adjusts for this cell only hiding three lines of text in
A1:C1. How do I get to see all six lines?

Thanks,

Gary


Gord Dibben MS Excel MVP