How to make a multi-column label?

C

Chip Pearson

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
 
T

Tom Ogilvy

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.
 
N

Norman Jones

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I run my spreadsheet on someone else's computer? 7
Lost Macro Control Characrters for Macros in Excel 1
Adding a DLL to Excel (2003) Object Browser 2
Calculating Dates from Non Leap Seconds 1
Why am I getting a "Type mismatch" Error 1
Why doesn't ths VBA Code work? 1
Knowing what Folder I'm in when I open from a shortcut 6
How do I create a "Certificate" for myself? 1

Top