Some users find AutoComplete disconcerting, dangerous, or merely annoying because if you
don’t pay close attention, you risk accidentally entering the wrong data. You can easily dis-
able AutoComplete: Choose Tools, Options, and click the Edit tab. Clear the check mark
from the Enable AutoComplete for Cell Values box. Click OK to save the new setting and
continue editing.
If you have a love-hate relationship with AutoComplete, create a macro that toggles this fea-
ture on and off. Assigning the macro to a toolbar button lets you turn on AutoComplete
when you’re entering data in a list where its capabilities ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month, and much more.