software

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 gt; Cells gt; Alignment gt; Text Alignment gt; Horizontal gt; Center
across selection

Hope this helps!

In article gt;,
DC25 gt; wrote:

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


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

You could also try merging the cells -

Highlight all Five cells - right click propertiesgt; Format Cellgt;
Alignment Tab.

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

Hope this helps

Kate--
Kate Williams

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

Vaya con Dios,
Chuck, CABGx3
quot;DC25quot; wrote:

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



quot;Domenicquot; wrote:

gt; Try the following...
gt;
gt; 1) Select/highlight your five cells
gt;
gt; 2) Format gt; Cells gt; Alignment gt; Text Alignment gt; Horizontal gt; Center
gt; across selection
gt;
gt; Hope this helps!
gt;
gt; In article gt;,
gt; DC25 gt; wrote:
gt;
gt; gt; I want to center a tittle across the top of five columns. I don't want the
gt; gt; heading to be separated by lines.
gt; Thank you very much, that helps alot.



quot;CLRquot; wrote:

gt; Another way is to just select the center cell of the five cells, enter your
gt; text, then do Richt-click gt; FormatCells gt; Alignment gt; and in the Horizontal
gt; window, select Center
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
Muchas gracias, me ayudaste bastante!
gt;
gt;
gt; quot;DC25quot; wrote:
gt;
gt; gt; I want to center a tittle across the top of five columns. I don't want the
gt; gt; heading to be separated by lines.

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 Sjoblomquot;Kate Williamsquot; gt; wrote in
message om...
gt;
gt; DC25 Wrote:
gt;gt; I want to center a tittle across the top of five columns. I don't want
gt;gt; the
gt;gt; heading to be separated by lines.
gt;
gt; You could also try merging the cells -
gt;
gt; Highlight all Five cells - right click propertiesgt; Format Cellgt;
gt; Alignment Tab.
gt;
gt; Place a tick in Merge cells and center the text using the drop down
gt; boxes.
gt;
gt; Hope this helps
gt;
gt; Kate
gt;
gt;
gt; --
gt; Kate Williams
Try using the Merge amp; Center button on format toolbar.
Example: Five columns.. Select (F3:J6)
Click - merge amp; center button on toolbar.
Bottom lines 3,4 amp; 5 vanish.

Find Merge amp; Center Command:
Click view on toolbar
click toolbar on list
select..customize....
on dialog box click command tab....categories.... select...format.....scroll
to merge amp; center..
click hold and drag to worksheet toolbar and release.DC25 wrote:
gt;I want to center a tittle across the top of five columns. I don't want the
gt;heading to be separated by lines.