Turn autocomplete data entry on or off in Excel 2007
Turn Autocomplete of cell entries 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 type 'Harry' or 'Manager', Excel automatically tries to complete the data entry. 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 autocomplete 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.
|
|