making a single cell the header for multiple rows

  • Thread starter thomas e donnelly
  • Start date
T

thomas e donnelly

i want to make one cell cover a number of rows ( ie cell a1 to be a header
for rows a b c d ) and actually cover a1 b1 c1
i have done it in the past but have forgotten how
any help would be appreciated
 
G

Guest

Hi
Type the title in the first of the cells. Seclect it along with the
remainder of the cells and use Centre Across Selection. This is the little
icon to the right of Right-justify and looks like a letter A on a brick
wall.
 
J

JE McGimpsey

Since the icon and button placement (or whether the button exists on a
default toolbar) varies between versions, you can also find it using
Format/Cells/Alignment/Horizontal -> Center across selection.
 
G

Gord Dibben

Andy

The "a" on a brick wall is the "Merge and Center"

Merging cells can cause no end of problems down the line.

There is no Toolbar button for "Center across selection".


Gord Dibben Excel MVP
 
G

Gord Dibben

Andy and OP

I have this assigned to a button.

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


Gord
 
Top