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.

This Site

Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.

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.