Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Assigning a Macro to a Keyboard Combination
Hiding Rows Based on a Cell Value
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 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.