Merge cells

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
Thu May 08 18:19:14 CDT 2008

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