Auto Row Height in Merged Cells with pre exisiting text
 

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

Auto Row Height in Merged Cells with pre exisiting text
 

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

Auto Row Height in Merged Cells with pre exisiting text
 

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