Turn Off AutoComplete

Recently I was using Excel's AutoComplete feature to quickly add some data to one of my spreadsheets. The data had many duplicates so AutoComplete helped to speed up the process quite a bit. AutoComplete, however, is not always so useful when it comes to entering data into spreadsheets.

If your data doesn't contain any duplicates, then AutoComplete can be more of a bother than a help. The black box containing the suggested completion shows up in the cell you are typing in, and while it does disappear if you keep typing, I find it distracting and I often end up with data entry errors.

When this starts happening, I find the best thing to do is to just turn AutoComplete off until I've finished entering data into my spreadsheets. It only takes a few clicks so it's easy to turn the feature off until you need it again. If you would like to do the same, read the article on how to Turn Off AutoComplete.

Related Articles

• Using AutoComplete to Enter Data
• Turn Off AutoComplete in Excel 2003