Using Auto Complete in Excel (and Word)

Auto Complete in EXCEL helps save time by reducing the amount of text we have to type (enter) when we are filling out a table with duplicate entries (like names, cities, states, and you can add more of your own... And this feature is also available in WORD.

 

By default, AutoComplete is turned on in Excel. These steps will first show you how to turn it off.

Turn AutoComplete On or Off in Excel 2010

• Click on the File tab of the ribbon to open the File menu
• Click on Options to bring up the Excel Options dialog box
• Click on the Advanced button in the left hand pane
• Under the Editing Options section
• Click on the Enable AutoComplete for cell values option box to remove the checkmark and Click OK
• AutoComplete should now be disabled
• To re-enable AutoComplete, re-check the option box

Turn AutoComplete On or Off in Excel 2007

• 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
• To re-enable AutoComplete, re-check the option box

Turn AutoComplete On or Off in Excel 2003

• On the Tools menu, click Options
• Now  click the Edit tab.
• To allow automatic completion, click to select the Enable AutoComplete for cell values check box.
• To prevent AutoComplete click to clear the check box.
• AutoComplete should now be disabled
• To re-enable AutoComplete, re-check the option box