How do I center a heading across cells?

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

Guest

I want to center a tittle across the top of five columns. I don't want the
heading to be separated by lines.
 
Try the following...

1) Select/highlight your five cells

2) Format > Cells > Alignment > Text Alignment > Horizontal > Center
across selection

Hope this helps!
 
Another way is to just select the center cell of the five cells, enter your
text, then do Richt-click > FormatCells > Alignment > and in the Horizontal
window, select Center

Vaya con Dios,
Chuck, CABGx3
 
Domenic said:
Try the following...

1) Select/highlight your five cells

2) Format > Cells > Alignment > Text Alignment > Horizontal > Center
across selection

Hope this helps!


Thank you very much, that helps alot.
Click to expand...
 
CLR said:
Another way is to just select the center cell of the five cells, enter your
text, then do Richt-click > FormatCells > Alignment > and in the Horizontal
window, select Center

Vaya con Dios,
Chuck, CABGx3
Click to expand...
Muchas gracias, me ayudaste bastante!
 
If it is possible to format (which it should be in this case) then merging
cells is not a good solution, there are so many problems involved with
merged cells (everything from copying and pasting to sorting and using
formulas)
 
Try using the Merge & Center button on format toolbar.
Example: Five columns.. Select (F3:J6)
Click - merge & center button on toolbar.
Bottom lines 3,4 & 5 vanish.

Find Merge & Center Command:
Click view on toolbar
click toolbar on list
select..customize....
on dialog box click command tab....categories.... select...format.....scroll
to merge & center..
click hold and drag to worksheet toolbar and release.
 
Back
Top