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.



Janice wrote:

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.

--

Dave Peterson

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

--
Don Guillett
SalesAid Software

"Janice" wrote in message
...
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.