Auto Complete
4 Answer(s)
Binny
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
May 25 2014 06:54 PM
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