Don't merge cells?

Thanks for your response, Roger. I am aware of this feature but I can't get it to produce the same effect as merging cells will. Am I missing something?

Let's say I have Jan Feb Mar ........ starting from A2 and going across.
Above the months and in row 1, I want to include a heading say "Monthly forecast for the year of 2007."

With merge cell feature, I can start typing "Monthly ......" in A1, and when I am finished keying, I can select my range and press the "merge and centre" button. It will be centered in one big cell.

With the format feature, I can't start typing in A1. If I do, then part of the heading will be truncated after I do format etc. and it won't centre although I tick the box. If I start typing in C1, I can see the entire heading but it won't centre either. Besides, the gridlines are there.

I have used format|alignment etc. for a single cell and it is fine. If I use it for multiple cells I usually click the "merge cells" box and it is fine too. But since we are on the subject of NOT merging, so I don't click the box and things just don't look right.

Wonder what's going on here.

Epinn

"Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:#IM3pfM1GHA.4976@xxxxxxxxxxxxxxxxxxxxxxx
Hi Epinn

Mark a range of cells
Format>Cells>Alignment>Centre across Selection

--
Regards

Roger Govier


"Epinn" <someone@xxxxxxxxxxxxxxxxxxx> wrote in message
news:e4cOkXM1GHA.1288@xxxxxxxxxxxxxxxxxxxxxxx
Bob,

Then, how do I spread a column heading across a few columns? Just don't
make it one big cell?

Epinn

"Bob Phillips" <bob.NGs@xxxxxxxxxxxxx> wrote in message
news:ObEjZUM1GHA.2196@xxxxxxxxxxxxxxxxxxxxxxx
Epinn,

Don't merge cells, it is more trouble than it is worth.

--
HTH

Bob Phillips

.