Tips, Tricks, and Answers

The following articles are available. 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Understanding AutoComplete Entering data in a worksheet can be a much easier task if you take advantage of the AutoComplete feature of Excel. This tip explains what the feature is, how it works, and how you can turn it on or off. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Using AutoComplete with Disjointed Lists AutoComplete is a great feature for data entry. However, it can lose some effectiveness if your data list has blank cells in it. This tip describes how to get around this shortcoming. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips

Advertise on the
ExcelTips Site

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)