Using the Fill Handle

These tutorial videos will teach you what is the fill handle, and how you can easily use it to create series of adjacent numbers or dates and save much of your working time. It can also be used to efficiently copy alternating texts.

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

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 want.