How do I center a heading across cells?

[Guest]

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

 

[Domenic]

Try the following...

1) Select/highlight your five cells

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

Hope this helps!

 

[Guest]

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

 

[Guest]

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.

 

[Guest]

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

Muchas gracias, me ayudaste bastante!

 

[Peo Sjoblom]

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)

 

[mcollin]

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.