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