Auto Complete

Is it possible to switch on and switch off the auto complete and how do you do it?

4 Answer(s)


no auto complete cannot be switched off....


No Mr.Bertrand AutoComplete CAnnot be Switchoff


no auto complete cannot be switched off....


If you are entering data into a spreadsheet that contains many duplicates, such as the place names or department titles Auto Complete can help to speed up data entry quite a bit.

Turn Auto Complete On or Off in Excel, follow these steps:
1) Click on Office Button > Excel Options to bring up the Excel Options dialog box

2) Click on the Advanced button in the left hand pane

3) Remove the checkmark from the Enable Auto Complete for cell values option box

4) Click OK

5) Auto Complete should now be disabled

6) To re-enable Auto Complete, re-check the option box