Tips, Tricks, and Answers
The following articles are available for the 'AutoComplete' topic. Click the article''s title (shown in bold) to see the associated article.
Making AutoComplete Work for an Entire Column
AutoComplete is a great feature for quickly adding data to a worksheet. If you are confused by why some things are picked up by AutoComplete and others aren't, you may find this tip helpful.
Entering data in a worksheet can be time consuming. One of the tools that Excel provides to make entry easier is AutoComplete, described in this tip.
Using AutoComplete with Disjointed Lists
AutoComplete can help you to more quickly enter information in a worksheet. How it works, behind the scenes, can affect how helpful it is for data entry.