Filling Cells

Tips, Tricks, and Answers

The following articles are available for the 'Filling Cells' topic. Click the article''s title (shown in bold) to see the associated article.

   Enhanced Filling
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.

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
Subscribe

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.