The Basics Calculations Special Features
Format Cells Statistical Functions The Fill Handle
Worksheets Quick Functions Charts (Graphs)
Edit Cells The IF Function Sort Data
Rows and Columns VLOOKUP Function Filter Data
Find and Replace Formulas First Aid
Home
Word Training
Updates
About
Guestbook
Links

Using the Fill Handle

The fill handle - with numbers
The fill handle - with text
The fill handle - with text & numbers
The fill handle - with dates

When should you use the fill handle?

Every time you want to get a series of data.

For example, you might want to number rows in the regular format of 1, 2, 3, 4… or maybe 10, 20, 30, 40… or maybe choose only to have even numbers: 2, 4, 6, 8…

The fill handle is very useful for creating lists of consecutive dates: either every day, every week, every month, year, or whatever difference between dates you need.