ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to make a multi-column label? (https://www.excelbanter.com/excel-programming/339630-how-make-multi-column-label.html)

Mac Lingo[_2_]

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



Chip Pearson

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




Tom Ogilvy

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





Norman Jones

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




Norman Jones

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







All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com