I WOULD NOT want that functionality unless it was an option I could turn off.
For me, those "auto complete" functions are simply a nuisance.
I agree with Lloyd on this - a feature that you could turn off...
Have to tell you... I'm glad I "flush this out of the bushes" (Ctrl-F2).... I'm in heaven! over having this ability! Who knew????

Something to note.... You have to hit the ENTER key after editing a cell (in the new-found edit feature) for the change to "take". If you click on the next cell without hitting ENTER, the change does no happen....