Related Article: Turn Off AutoComplete in Excel 2003
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 2007
Note: For help with these steps, see the image to the right.
- Click on Office Button > Excel Options to bring up the Excel Options dialog box.
- Click on the Advanced button in the left hand pane.
- Remove the checkmark from the Enable AutoComplete for cell values option box.
- Click OK.
- AutoComplete should now be disabled.
Related Articles
