Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 53
Default How to make a multi-column label?

How do you make a multu-column label?
Tnx,
Mac Lingo
Berkeley, CA


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default How to make a multi-column label?

There isn't really such a thing as a multi-column label.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Mac Lingo" wrote in message
. net...
How do you make a multu-column label?
Tnx,
Mac Lingo
Berkeley, CA



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How to make a multi-column label?

Enter the value in the cell of the first column

Now select that cell and the "n-1" cells to the right so you have "n" cells
selected. No do format=Cells and select the alignment tab.

You can do Center Across Selection for the horizontal alignment.

An alternative is to check the merged cells check box.

--
Regards,
Tom Ogilvy

"Mac Lingo" wrote in message
. net...
How do you make a multu-column label?
Tnx,
Mac Lingo
Berkeley, CA




  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default How to make a multi-column label?

Hi Max,

Perhaps you could use multiple labels, one for each column?


---
Regards,
Norman



"Mac Lingo" wrote in message
. net...
How do you make a multu-column label?
Tnx,
Mac Lingo
Berkeley, CA



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default How to make a multi-column label?

Hi Max,

I read your request as relating to a label control, possibly on a userform.

If that is not the case, please ignore my suggestion.


---
Regards,
Norman



"Norman Jones" wrote in message
...
Hi Max,

Perhaps you could use multiple labels, one for each column?


---
Regards,
Norman



"Mac Lingo" wrote in message
. net...
How do you make a multu-column label?
Tnx,
Mac Lingo
Berkeley, CA







Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make multi column stacked graphs in Excel Ed B Charts and Charting in Excel 1 October 20th 07 11:40 AM
how to label multi cells respectively in excel alexasanford Excel Worksheet Functions 4 March 6th 07 09:06 PM
Column chart - category axis - make to start with the second label Marko Pinteric Excel Discussion (Misc queries) 3 April 10th 06 09:31 AM
Column chart - category axis - make to start with the second label Marko Pinteric Charts and Charting in Excel 3 April 10th 06 09:31 AM
Extract values from a multi-select multi-column list-box Peter[_20_] Excel Programming 5 September 28th 03 04:04 PM


All times are GMT +1. The time now is 11:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"