Merge cells

[tshad]

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]

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