Disable autocomplete for cell values in Excel 2010.
If you find it annoying to have the autocomplete features in Excel, you can turn it off.
To turn it off is to click on the ribbon or go to “File”.
Click on “Options”.
Excel option window will pop-up.
Click the “Advanced” options.
Untick “Enable Autocomplete for cell Values”.
Check out this screen shot below: