
Tips.Net > ExcelTips Home > Data Entry > Filling Cells > Enhanced Filling
Summary: The AutoFill tool in Excel is very handy to use. If you know the little trick disclosed in this tip, you can make AutoFill even handier. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
Excel allows you to quickly and easily fill a series of cells with a progression of values by simply using the fill handle. This is the small black dot that appears at the lower-right corner of a cell when it is selected. Just click on the fill handle and drag to select the cells you want filled. Using this feature allows Excel to make decisions about how the cells you select should be filled.
You can gain more control over the filling process if, instead of clicking on the fill handle, you right-click on it and then drag. When you release the mouse button a Context menu appears that allows you to select the type of fill you want to perform.
Tip #2095 applies to Microsoft Excel versions: 97 2000 2002 2003
Make Home Buying Less Stressful! Why face the annual problems associated with Christmas debt? Learn how to avoid that debt and conquer your financial challenges.
Check out Buying a Home Checklist today!
If you have tons of data to analyze, one of the best tools in Excel's arsenal is the PivotTable. Learn how to use this tool to analyze your data. (more information...)
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
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