View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I put one heading over 3 narrow columns?

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