How do I put one heading over 3 narrow columns?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make an excel sheet that has the year "2006" over 3 narrow
columns that just have an "X" in or they are blank. I cannot figure out how
to put the 2006 so that it shows especially when I print sheet.
 
Select your 3 cells (say A1:C1)
format|cells|Alignment tab|Horizontal dropdown|Center Across Selection

And type your value in A1 (the leftmost cell) with nothing in the other two
cells.
 
Put this in your personal.xls macro workbook and assign a custom toolbar
button to it. Then select your area to center across and click on the custom
button.

Sub CENTERACROSS()
With Selection
If .HorizontalAlignment = xlCenterAcrossSelection Then
.HorizontalAlignment = xlGeneral
Else
Selection.HorizontalAlignment = xlCenterAcrossSelection
End If
End With
End Sub
 
Back
Top