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.

   Understanding AutoComplete
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.

Newest Tips

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.

Links and Sharing