WRAP TEXT

I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP
TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL
THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE RIGHT.
I AM SETTING UP A WORKSHEET TO BE USED AS A LAW FIRM'S
INVOICE AND NEED THE CELL WHERE THE NARRATIVE OF SERVICES
GOES TO WRAP THE TEXT

Lynn

First, please turn off CAPS LOCK. Most find it hard to read and is considered
"shouting".

Second.......

Merged cells will allow "wrap text" from FormatCellsAlignment but..........

Excel has a problem auto-fitting merged cells.

You can resize manually or via Macro. Jim Rech has written
code for this.

http://groups.google.com/groups?thre...%40tkmsftngp05

Note also a recent adaptation of this code by Greg Wilson.

http://makeashorterlink.com/?P37D24B15

The best cure is DON"T USE MERGED CELLS. They cause no end of problems with
copying, pasting, sorting, filtering.

Gord Dibben Excel MVP


On Sat, 12 Jun 2004 17:16:45 -0700, "LYNN" wrote:

I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP
TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL
THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE RIGHT.
I AM SETTING UP A WORKSHEET TO BE USED AS A LAW FIRM'S
INVOICE AND NEED THE CELL WHERE THE NARRATIVE OF SERVICES
GOES TO WRAP THE TEXT

Please turn off your CAPS Lock - it's considered the equivalent of
shouting in newsgroups, and more importantly, is more difficult to read.

I assume you mean that the cell height doesn't adjust automatically when
merged cells (which should never, IMHO, be used) are set to wrap text.

If that's the case, see Jim Rech's macro solution:

http://google.com/groups?selm=uGMQVj...40TK2MSFTNGP10




In article ,
"LYNN" wrote:

I HAVE TRIED TO DO FORMAT, CELLS, ALIGNMENT & WRAP
TEXT...IT DOES NOT WORK. I'M TRYING TO DO THIS IN A CELL
THAT HAS BEEN MERGED WITH THREE OTHER CELLS TO THE RIGHT.
I AM SETTING UP A WORKSHEET TO BE USED AS A LAW FIRM'S
INVOICE AND NEED THE CELL WHERE THE NARRATIVE OF SERVICES
GOES TO WRAP THE TEXT