Related Article: Turn Off AutoComplete in Excel 2007
If you are entering data into a spreadsheet that contains many duplicates, such as the place names or department titles AutoComplete can help to speed up data entry quite a bit.
If your data doesn't contain any duplicates, then AutoComplete can be more of a bother than a help. This tip will show you how to turn off this sometimes overly helpful feature.
Turn Off AutoComplete in Excel 2003
Note: For help with these steps, see the image to the right.
- Click on Tools > Options in the menus to bring up the Options dialog box.
- Click on the Edit tab.
- Remove the checkmark from the Enable AutoComplete for cell values option box.
- Click OK.
- AutoComplete should now be disabled.
Related Articles
