merge and wrap

[David Fore]

I'm formatting an excel spreadsheet.
I'm using merge horizontally to get comments spread across multiple
cells.
I.E.

name ______ comapny _______ date _______

Data data data <--- comments ------->

If me comments go beyond the end, the text wraps, but it doesn't
display on the page. It's like the row height is fixed, but it's not.
Can anybody help?

David

 

[JE McGimpsey]

Try Jim Rech's workaround for autosizing rows of merged cells:

http://google.com/groups?selm=uGMQVjd0CHA.2296@TK2MSFTNGP10

 

[Frank Kabel]

Hi David
Excel has probelms with merged cells and automativ width/height
adjusting. So you have to change the row heigth manually.

Note: I really would recommend to NOT use merged cells as they cause
many problems (e.g. sorting, filtering, etc.)

 

[Ragdyer]

Would suggest that you use "CenterAcrossSelection" instead of using "Merge"!

Besides avoiding all the problems that merged cells can create, you can
obtain the benefits of automatic row height adjustment, and the display is
just about identical.

Select the cells concerned, then:

<Format> <Cells> <Alignment> tab,
Expand the "Horizontal" box and click on "CenterAcrossSelection"
Make sure "WrapText" is checked, then <OK>.

What does that commercial say ...
Try it ... You'll like it!