RD,
You're right. I meant just keep typing ignoring the selected text that Autocomplete has
added -- it goes away, like any selected text when you type.
If you wanted to change the text that Autocomplete has put in, you could press F2 to switch
from Enter to Edit mode, then use the left arrow key to move the cursor to the point where
you want to change the text, or use the Backspace key to delete text from the end.
It's a bit of an exercise, to be sure -- Excel worksheets don't behave the way most forms
(both in PC software and on web pages) behave, where you can just click in a field (or tab
into it), putting the cursor there, then move it to wherever you want in any existing text
with the arrow keys. There, everything is in front of you, and there's no Enter Mode versus
Edit Mode to be aware of. But if there many such changes to be made, it can be worth the
discipline.
--
Earl Kiosterud
www.smokeylake.com
Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.
-----------------------------------------------------------------------
Ragdyer said:
I would assume that Earl was referring to the *continuation* of typing in
the next value, ignoring what was chosen (displayed) by XL as an
AutoComplete suggestion. Any deviation from the AutoComplete suggestion
*cancels* it.
The problem only comes into play when the next data to be entered is
*shorter* then the AutoComplete suggestion, therefore not allowing a (the)
change to become apparent to XL.
