Removal of lines

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

annonymous@discussions.microsoft.com - 09 Jan 2006 08:17 GMT

I am just a self taught beginner, so could someone please explain to me how
can I remove the lines separating the columns e.g. between columns A B & C,
in lines 1 and 2, so that if I have a heading on a worksheet, which is meant
to incorporate more than one column, e.g. 2006, so that I could then insert
the months in the next line 3.
How do I retain the year 2005 numerals in the middle of the line? Thank you.

Reply to this Message

Roger Govier - 09 Jan 2006 09:38 GMT

Hi

You could mark your range of cells, A1:C1 and
Format>Cells>Alignment>Merge then choose Alignment>Horizontal>Center.
Personally, I avoid merged cells where possible, as there can be
problems with Sorting etc. (unlikely in this case).

The alternative, is to select the three cells, Format>Cells>Alignment
and choose Centre across selection.

Signature

Regards

Roger Govier

>I am just a self taught beginner, so could someone please explain to me
>how can I remove the lines separating the columns e.g. between columns
[quoted text clipped - 3 lines]
> How do I retain the year 2005 numerals in the middle of the line?
> Thank you.

Reply to this Message