Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / May 2008

Tip: Looking for answers? Try searching our database.

Merge cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
tshad - 08 May 2008 19:43 GMT
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.