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.
The following articles are available for the 'Filling Cells' topic. Click the article's title (shown in bold) to see the associated article.
Using the AutoFill feature of Excel is very handy. If you want to expand the utility offered by the feature, all you need to do is change how you click the AutoFill handle.
Using the Fill Handle from the Keyboard
The fill handle can save a huge amount of time when you are editing a worksheet. If you are really good at using the keyboard but dislike using the mouse, you may want to use the capabilities of the fill handle without removing your hands from the keyboard.
Working with Record Numbers
Want to keep track of various rows in a data table through the use of record numbers? Here are some options and considerations you should keep in mind.