text wrap w/ merged cells
 

I have 3 column that are merged cells that I would like to text wrap. I
understand that Excel has a problem doing this, but is there some sort of
formatting I can to make it automaticaly adjust my row height. If there is
then please let me know. Normally I would just do it manually but there are
some formulas I don't want screwed up and other people will be entering data
so I want to protect my worksheet.....Thanks in advance for any help or
attempted help.
Travis

No, there's no formatting that will adjust row-height on merged, wrapped
cells. If you look in the archives, you'll find a macro by Jim Rech that
will do this for you.

http://groups.google.com/advanced_gr...ugroup=*excel*

In article ,
"Dahlman" wrote:

I have 3 column that are merged cells that I would like to text wrap. I
understand that Excel has a problem doing this, but is there some sort of
formatting I can to make it automaticaly adjust my row height. If there is
then please let me know. Normally I would just do it manually but there are
some formulas I don't want screwed up and other people will be entering data
so I want to protect my worksheet.....Thanks in advance for any help or
attempted help.

I copy and pasted the macro code but it doesn't work. I'm not at all familiar
with macros. Can you maybe give me a quick step by step on how to go about
it?. Thanks in advance.


"JE McGimpsey" wrote:

No, there's no formatting that will adjust row-height on merged, wrapped
cells. If you look in the archives, you'll find a macro by Jim Rech that
will do this for you.

http://groups.google.com/advanced_gr...ugroup=*excel*

In article ,
"Dahlman" wrote:

I have 3 column that are merged cells that I would like to text wrap. I
understand that Excel has a problem doing this, but is there some sort of
formatting I can to make it automaticaly adjust my row height. If there is
then please let me know. Normally I would just do it manually but there are
some formulas I don't want screwed up and other people will be entering data
so I want to protect my worksheet.....Thanks in advance for any help or
attempted help.

See David McRitchie's "Getting Started with Macros":

http://www.mvps.org/dmcritchie/excel/getstarted.htm


In article ,
"Dahlman" wrote:

I copy and pasted the macro code but it doesn't work. I'm not at all familiar
with macros. Can you maybe give me a quick step by step on how to go about
it?. Thanks in advance.