I have a set of tables where I am putting descriptions before the tables
that I would like to wrap. But the wrapping seems to be only for a specific
cell.
I would like my comments to span multiple cells and act as one cell, then
wrap in that one new cell.
I can do one row of text where the text spans multiple cells as long as
there is nothing in the cells to the right. But I can't wrap a paragraph
that way.
In html, I would just do a Colspan= 5 to have the 1st span 5 cells as one.
Can you do this type of thing in Excell 2007?
I can use a label, but was curious if you can do it the other way.
Thanks,
Tom
Gord Dibben - 09 May 2008 00:19 GMT
Before you get too far into this..........beware merged cells..........they
cause no end of problems with copying, pasting, sorting, filtering and a bunch
of others.
You can wrap text in merged cells same as you would in a single(which merged
cells become).
Select A1:A5 and Format>Cells>Alignment>Merge cells.
Or A1:E5 and merge them.
Then set to wrap text.
What won't happen is row autofit with merged cells.
Gord Dibben MS Excel MVP
>I have a set of tables where I am putting descriptions before the tables
>that I would like to wrap. But the wrapping seems to be only for a specific
[quoted text clipped - 16 lines]
>
>Tom