Roger,

It's hard for me to explain without the screen. I heard you and I followed exactly what you said previously. Maybe if you try to actually do what I did, say keying into A1, you'll know what I mean?? Data didn't get truncated while typing but after formatting. If I start in A1 (i.e. following your previous instructions) the first part (monthly fore) of the title gets truncated *after* the format. It has nothing to do with column width. I'll digest your new post some more later. I key in before I format, right?

Thank you for filling in the blank. I have been wondering what the last "n" of Epinn should stand for. You just gave me the answer. Yes, "n" for number. That's very good and it makes sense. As I said, "e" stands for electronic. "Pinn" is actually the first part of a word (talking about truncation) which I use as my cyber last name. Confused? But, "electronic PIN number" is really good. So, I have "made a name" for myself on this board.

The other day, Bob asked me about my nationality, now you want to know my gender? My dear friendsss, someone who frequents the MS boards has been watching me closely for quite a while and finally he revealed himself to me. He may even be reading this post while you do. I should really keep a low profile and refrain from posting. I hope you do understand. If anyone secretly finds out anything about me, I urge you to keep it to yourself and don't advertise it on the board. If you have figured out the long form of Pinn, please don't say it. It's okay to repeat what I have told you via my posts though. I should do a better job not to reveal too much of myself. Identity theft is a big thing. Someone's house was sold as a result of title fraud, identity theft etc. and the genuine owner still couldn't get it back after seven months and thousands and thousands of $$$$.

Sorry for the distraction and I wish everyone safety on the 10th. of September.

Electronic Pin Number

"Roger Govier" wrote in message ...
Hi Epinn

Mark the range of cells A1:C1, then
FormatCellsAlignmentSelect the Horizontal dropdownCenter across
selection
There is nothing to stop you from starting to type in A1.
If the data is truncated, then you need to widen the columns.
You do not get gridlines in between.

If you do not have any data in B1 or C1, then just typing the whole of
the text in A1, will give the appearance of a single cell without
gridlines

Choosing Merge, also truncates the data, unless you widen the column(s)

Incidentally, I noted from earlier postings Epinn is an acronym of
(Electronic (pin) (n)umber but you do not say whether you are male or
female?

--
Regards

Roger Govier


"Epinn" wrote in message
...
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" wrote in message
...
Hi Epinn

Mark a range of cells
FormatCellsAlignmentCentre across Selection

--
Regards

Roger Govier


"Epinn" wrote in message
...
Bob,

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

Epinn

"Bob Phillips" wrote in message
...
Epinn,

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

--
HTH

Bob Phillips