Tweet
Disable Cell Value AutoComplete
SUMMARY: Prevent Excel 2003 from guessing the values you wish to enter in cells.
You may have noticed when entering data in Microsoft Excel 2003 spreadsheets that if you start to enter data that looks similar to that already entered previously in a particular spreadsheet, Excel will attempt to automatically complete your typing. This way, instead of entering the same information twice, you can merely tab or cursor to another cell and Excel will complete your typing for you.
AutoComplete is not perfect, however, and many people find this feature annoying. If you're one of them and wish to turn it off:
1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "Edit" tab.
3. Uncheck "Enable AutoComplete for cell values".
4. Click "OK" to close the dialog box.
SUMMARY: Prevent Excel 2003 from guessing the values you wish to enter in cells.
You may have noticed when entering data in Microsoft Excel 2003 spreadsheets that if you start to enter data that looks similar to that already entered previously in a particular spreadsheet, Excel will attempt to automatically complete your typing. This way, instead of entering the same information twice, you can merely tab or cursor to another cell and Excel will complete your typing for you.
AutoComplete is not perfect, however, and many people find this feature annoying. If you're one of them and wish to turn it off:
1. Click "Tools" - "Options".
2. When the "Options" multi-tabbed dialog box appears, click the "Edit" tab.
3. Uncheck "Enable AutoComplete for cell values".
4. Click "OK" to close the dialog box.
Comment