How to disable autocomplete feature in Excel 2010 ?

By default , Excel 2010 uses the AUtocomplete feature which will suggest you the words based on the values that was recently entered in the cells of the Worksheet .

You might sometimes want to disable this feature, which you can do it easily in Excel 2010 .
1. Go to File – > Options

2. In the Excel Options Dialog , navigate to the Advanced tab and then uncheck the option “Enable Autocomplete for Cells” .

3. This will disable the Autocomplete feature for cell . To enable the autocomplete feature again , just check the option back .

Recently Searched terms :

Share