Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Misc

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.

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Misc page.

Print this tip.

- Subscribe!

Search the Site: