I am newly to use excel 2007, why it will automatically copy the last text
that I had entered and paste to the next cell together with the new text?
What I mean if I typed 123 for one cell and entered, then I type abc on a new
cell, the worksheet will appears with 123abc? Pls adv how to fix it, thanks.

There's a setting that matches what you're typing to something you've
already entered in that column and fills it in. For example, if you have
typed abc123, then in another cell start typing abc, as soon as what you
type only matches one entry, it fills in, so it woould look like abc123,
with the characters you haven't yet typed highlighted in black. If you hit
the backspace or delete key, the highlighted part is removed. However, if
you hit enter, any highlighted (untyped) characters will be accepted.

This is not new in Excel 2007. Now that you are aware of this behavior you
might want to keep it. But if you decide to turn it off, click on the big
round ugly button in the top left, then click on Excel Options, select
Advanced, then uncheck the box that says "Enable autocomplete for cell
values".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Aux1712" wrote in message
...
I am newly to use excel 2007, why it will automatically copy the last text
that I had entered and paste to the next cell together with the new text?
What I mean if I typed 123 for one cell and entered, then I type abc on a
new
cell, the worksheet will appears with 123abc? Pls adv how to fix it,
thanks.

Hi Jon,
Tks for your reply. But my case is when I typing something same as previous,
it didn't show up in black col but invisible, I did uncheck what you said but
it still appears the same, but one thing is strange, not all the cells I
entered will have the same problem, the first two cells I did was normal, but
when it came up to 3 or 4 cells, it will have such problem, also I realize
there is a small 'text' (appears same as the last typed) appear a little bit
down from the cell I am typing, but when I point to cursor to it, it will
disappear immd.

"Jon Peltier" wrote:

There's a setting that matches what you're typing to something you've
already entered in that column and fills it in. For example, if you have
typed abc123, then in another cell start typing abc, as soon as what you
type only matches one entry, it fills in, so it woould look like abc123,
with the characters you haven't yet typed highlighted in black. If you hit
the backspace or delete key, the highlighted part is removed. However, if
you hit enter, any highlighted (untyped) characters will be accepted.

This is not new in Excel 2007. Now that you are aware of this behavior you
might want to keep it. But if you decide to turn it off, click on the big
round ugly button in the top left, then click on Excel Options, select
Advanced, then uncheck the box that says "Enable autocomplete for cell
values".

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Aux1712" wrote in message
...
I am newly to use excel 2007, why it will automatically copy the last text
that I had entered and paste to the next cell together with the new text?
What I mean if I typed 123 for one cell and entered, then I type abc on a
new
cell, the worksheet will appears with 123abc? Pls adv how to fix it,
thanks.