This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Misc - Disable Cell Value AutoComplete

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.



Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Misc - Disable Cell Value AutoComplete.
 
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.