Wrap Text with a Merged Cell!

V

Victor

I am haveing trubble with wraping text when i have more than one cell that
are merged together. I put a check mark to select Wrap Text but when i type
data into that cell it dose not wrap the text. If anyone can help i would
be realy thankfull.

OS 10.3.7
Office X
 
J

JE McGimpsey

Victor said:
I am haveing trubble with wraping text when i have more than one cell that
are merged together. I put a check mark to select Wrap Text but when i type
data into that cell it dose not wrap the text. If anyone can help i would
be realy thankfull.
Click to expand...

First - merged cells cause a host of problems, not only with wrapping,
but with sorting, filtering, formatting, copying, pasting, etc., and,
IMNSHO, should never be used. Ever.

But if you must merge, you can use VBA to wrap the text. Search the
microsoft.public.excel* group archives:

http://groups.google.com/advanced_group_search?as_ugroup=*excel*

using the keywords merge, wrap, etc., and you'll find references to a
macro by Jim Rech that will work for you.
 
Top