![[Home]](http://malektips2.com/graphics/logo-small.png){kind=logo}
Microsoft Excel 2010
Disable Cell AutoComplete
SUMMARY: Tired of Excel 2010 "suggesting" that you are retyping the same information over and over? Turn off cell value AutoComplete.
Have you ever grown tired of Microsoft Excel 2010 "suggesting" what to enter in a cell based on what you have entered into previous cells? This is called autocompleting, a feature that may save you time if you frequently re-enter the same data into different cells.
But what if you are entering data that is similar but not exactly the same as previous data, for example a group of hundreds of names where it is possible that some people have the same last names? If you previously typed in "Smith, John" and begin typing in "Smith, Walter", for example, Excel will "suggest" that your second cell entry be "Smith, John". If you tire of this "feature", do the following to disable it:
1. Select the "File" tab in the Ribbon.
2. The Microsoft Office Backstage View appears. Click the "Options" button.
(Or instead of steps 1 and 2, press Alt + T, then the letter O.)
3. The "Excel Options" dialog box appears. Click "Advanced" in the left pane.
4. Underneath "Editing options", uncheck "Enable AutoComplete for cell values".
5. Click "OK" on the bottom-right of the dialog box to close it.
Return to the Microsoft Excel 2010 page.
blog comments powered by Disqus
