2 columns under one heading

[johnnycake23]

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.

 

[JE McGimpsey]

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

 

[Zone]

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

 

[johnnycake23]

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



- Show quoted text -

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

 

[RagDyeR]

For example, select D1 and E1, and type:
Burger
Then <Alt> <Enter>
Then Cheeseburger<space><space>Hamburger
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!
=====================================================


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.

 

[Guest]

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?

 

[Gord Dibben]

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

 

[JE McGimpsey]

I assigned FaceID 386 to my custom button.