Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
General
GeneralPortable MacsHardwareNetworking
Applications
Mac ApplicationsEudoraFirefox / MozillaInternet ExplorerOutlook ExpressMS OfficeEntourageExcelPowerPointWordVirtual PCMedia PlayerOther MS Products
Programming
Mac ProgrammingCodeWarriorPerl
Country Specific
Australian Mac GroupUK Mac Group

Mac Forum / Applications / Excel / May 2008


Tip: Looking for answers? Try searching our database.

Column lables

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jlasek@officeformac.com - 28 Apr 2008 22:34 GMT
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel

How can I make a label extend over 2 columns?
Reply to this Message
Bob Greenblatt - 28 Apr 2008 23:04 GMT
On 4/28/08 5:34 PM, in article ee99d96.-1@webcrossing.caR9absDaxw,

> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
>
> How can I make a label extend over 2 columns?
Just type in a cell. If there is nothing in the ceil to the right, the text
will flow into it.

Signature

Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom

Reply to this Message
panthergpss@officeformac.com - 28 Apr 2008 23:47 GMT
Type the label over the first column. Highlight that column and the one to the left. Merge the two cells. Then align the label using centre alignment.
Reply to this Message
panthergpss@officeformac.com - 28 Apr 2008 23:52 GMT
OOPS
> Type the label over the first column. Highlight that column and the one to the RIGHT. Merge the two cells. Then align the label using centre alignment.
Reply to this Message
JE McGimpsey - 29 Apr 2008 06:10 GMT
> OOPS
> > Type the label over the first column. Highlight that column and the one to
> > the RIGHT. Merge the two cells. Then align the label using centre
> > alignment.

I generally advise against merging cells - it interferes with sorting,
copy/pasting, etc...

Center Across Selection has none of the disadvantages of merging.

Merging, IMNSHO, is almost never worth the disadvantages.
Reply to this Message
panthergpss@officeformac.com - 02 May 2008 01:19 GMT
Thanks J. E.
I hadn't considered the problems that merging could create when one wanted to work with the information. I was just thinking of a label and not the other possibilities.
Dave
Reply to this Message
JE McGimpsey - 29 Apr 2008 06:07 GMT
> Version: 2008
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
>
> How can I make a label extend over 2 columns?

Enter the label in the left-most cell. Select that cell and the cell to
the right. Choose Format/Cell/Alignment, and choose Center Across
Selection from the Horizontal dropdown.
Reply to this Message
 
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.