merge and wrap

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

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

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



In article ,
(David Fore) wrote:

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?

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.)


--
Regards
Frank Kabel
Frankfurt, Germany


David Fore wrote:
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

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!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"David Fore" wrote in message
om...
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