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

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


On Thu, 8 May 2008 11:43:00 -0700, "tshad" <tshad@dslextreme.com> wrote:

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