How do I center a heading across cells?

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!

In article <86DFF28E-0D03-4ABB-9DD2-675299247A05@microsoft.com>,
DC25 <DC25@discussions.microsoft.com> wrote:

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

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



"DC25" wrote:

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

"Domenic" wrote:

> Try the following...
>
> 1) Select/highlight your five cells
>
> 2) Format > Cells > Alignment > Text Alignment > Horizontal > Center
> across selection
>
> Hope this helps!
>
> In article <86DFF28E-0D03-4ABB-9DD2-675299247A05@microsoft.com>,
> DC25 <DC25@discussions.microsoft.com> wrote:
>
> > I want to center a tittle across the top of five columns. I don't want the
> > heading to be separated by lines.
> Thank you very much, that helps alot.

"CLR" wrote:

> 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!
>
>
> "DC25" wrote:
>
> > I want to center a tittle across the top of five columns. I don't want the
> > heading to be separated by lines.

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

You could also try merging the cells -

Highlight all Five cells - right click properties> Format Cell>
Alignment Tab.

Place a tick in Merge cells and center the text using the drop down
boxes.

Hope this helps

Kate


--
Kate Williams

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)


--

Regards,

Peo Sjoblom


"Kate Williams" <Kate.Williams.253bhn@news.officefrustration.com> wrote in
message news:Kate.Williams.253bhn@news.officefrustration.com...
>
> DC25 Wrote:
>> I want to center a tittle across the top of five columns. I don't want
>> the
>> heading to be separated by lines.
>
> You could also try merging the cells -
>
> Highlight all Five cells - right click properties> Format Cell>
> Alignment Tab.
>
> Place a tick in Merge cells and center the text using the drop down
> boxes.
>
> Hope this helps
>
> Kate
>
>
> --
> Kate Williams

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.


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