How to turn auto-complete data entry on or off in Excel 2007
When you enter data into Excel worksheet cells, you would have observed that the program recognizes an earlier entry that you had made. In our example when we wish to type Mathew but Excel automatically tries to complete the data entry by entering Mason. This is a cause of serious irritation for beginners. For advanced users of Excel this can be a source of errors, particularly if somebody is in a hurry. For some savvy Excel users the autocomplete feature improves productivity. You can turn the auto-complete feature on or off by clicking on the office button, selecting Excel options, then selecting the ‘advanced’ link and finally enabling or disabling the feature as shown in the training video.
Using (or Disabling) Excel 2007’s AutoComplete Feature