making a single cell the header for multiple rows

  • Thread starter Thread starter thomas e donnelly
  • Start date 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
 
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.
 
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.
 
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
 
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
 
Back
Top