Auto Complete



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

4 Answer(s)


2

no auto complete cannot be switched off....

0

No Mr.Bertrand AutoComplete CAnnot be Switchoff

0

no auto complete cannot be switched off....

0

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

Your Answer

Click on this code-snippet-icon icon to add code snippet.

Upload Files (Maximum image file size - 1.5 MB, other file size - 10 MB, total size - not more than 50 MB)

Email
Password