2 columns under one heading
 

I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.

Answer: 2 columns under one heading
 

Yes, you can definitely put two columns under one heading in Excel. Here's how you can do it:

1. Open a new or existing Excel worksheet.
2. Type the heading "Burger" in cell A1.
3. Type "Cheeseburger" in cell B1 and "Hamburger" in cell C1.
4. Select cells B1 and C1 by clicking and dragging your mouse over them.
5. Right-click on the selected cells and choose "Format Cells" from the drop-down menu.
6. In the "Format Cells" dialog box, click on the "Alignment" tab.
7. Under "Horizontal," select "Center Across Selection" from the drop-down menu.
8. Click "OK" to close the dialog box.

Now, the text "Cheeseburger" and "Hamburger" will be centered under the heading "Burger" and will appear as two columns under one heading. You can adjust the width of the columns by clicking and dragging the column divider between columns B and C.

2 columns under one heading
 

One way:

Put "Burger" in the heading cell of the left-hand column. Select that
cell and the one to the right. Choose Format/Cells/Alignment, and choose
Center across Selection from the Horizontal: dropdown.

You *could* also merge the two cells and center the text, but merged
cells are the devil's invention, and should never, ever, be used. Not
even once...

In article . com,
wrote:

I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.

2 columns under one heading
 

Say Cheeseburger is in cell H2 and Hamburger is in cell I2. Type Burger
into cell H1 and press Enter. Select cells H1 and I1. Select Format from
the menubar, then Cells. On the Alignment tab, Horizontal Box, choose
Center Across Selection. James
wrote in message
ups.com...
I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.

2 columns under one heading
 

On Oct 12, 7:21 am, JE McGimpsey wrote:
One way:

Put "Burger" in the heading cell of the left-hand column. Select that
cell and the one to the right. Choose Format/Cells/Alignment, and choose
Center across Selection from the Horizontal: dropdown.

You *could* also merge the two cells and center the text, but merged
cells are the devil's invention, and should never, ever, be used. Not
even once...

In article . com,



wrote:
I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.- Hide quoted text -

- Show quoted text -

Great. That should do it. Thank you for your help.

2 columns under one heading
 

For example, select D1 and E1, and type:
Burger
Then <Alt <Enter
Then Cheeseburger<space<spaceHamburger
Then <Enter

While those 2 cells are *still* selected, from the menu bar,
<Format <Cells <Alignment tab,

Expand the "Horizontal" box, and click on <Center Across Selection,
Expand the "Vertical" box, and click on <Center
Under "Text Control", click on <Wrap Text

Then <OK
NOW ... expand the columns until you have your 2 line header.
Play with the number of spaces between the text until you have what you
want.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===


wrote in message
ups.com...
I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.

2 columns under one heading
 

I agree with this way to fix the problem; i have looked for a long time for
an icon I could put in my toolbar to save the multiple steps to make it work.
Does anyone know of such an icon?

"JE McGimpsey" wrote:

One way:

Put "Burger" in the heading cell of the left-hand column. Select that
cell and the one to the right. Choose Format/Cells/Alignment, and choose
Center across Selection from the Horizontal: dropdown.

You *could* also merge the two cells and center the text, but merged
cells are the devil's invention, and should never, ever, be used. Not
even once...

In article . com,
wrote:

I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.

2 columns under one heading
 

There is no icon for "center across selection"

I wrote my own and assigned it to a button on my toolbar.

Sub TOGGLECENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub

You could assign to a shortcut key.


Gord Dibben MS Excel MVP

On Wed, 14 Nov 2007 13:55:01 -0800, K Bronson <K
wrote:

I agree with this way to fix the problem; i have looked for a long time for
an icon I could put in my toolbar to save the multiple steps to make it work.
Does anyone know of such an icon?

"JE McGimpsey" wrote:

One way:

Put "Burger" in the heading cell of the left-hand column. Select that
cell and the one to the right. Choose Format/Cells/Alignment, and choose
Center across Selection from the Horizontal: dropdown.

You *could* also merge the two cells and center the text, but merged
cells are the devil's invention, and should never, ever, be used. Not
even once...

In article . com,
wrote:

I need to put two columns under one heading in Excel. Is there any
way this can be done? For example, let's say I need the heading
Burger, and underneath that heading I need one column reading
cheeseburger and the other hamburger, both under the same heading.
Does that make sense? Can this be done? Thank you for your help.

2 columns under one heading
 

I assigned FaceID 386 to my custom button.


In article ,
K Bronson <K wrote:

I agree with this way to fix the problem; i have looked for a long time for
an icon I could put in my toolbar to save the multiple steps to make it work.
Does anyone know of such an icon?