HDTutorial
EN
How to Turn OFF or ON Autocomplete in Excel 2007

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Turn OFF or ON Autocomplete in Excel 2007

11,864 views November 15, 2013 1:47

Watch on YouTube
ChannelDinesh Kumar Takyar

Description from the creator

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 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.
Details available at exceltrainingvideos.com/turn-autocomplete-data-…

About this tutorial

Dinesh Kumar Takyar published this 1:47 video tutorial on November 15, 2013. It has been watched 11,864 times on YouTube.

Category
Education
Duration
1:47
Published
November 15, 2013
Views
11,864
Likes
45

Share

This tutorial in other languages