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.