Auto fill occurs when Excel automatically fills selected
data. Excel has several preset series (months of the year and days of the week) that are used with the
If January is typed in a cell and then the fill handle used to select adjacent cells, Excel will fill those cells with the next names in the series â€“ February, March, April and so on.
Users can add their own series to this list by going to Tool > Options > Custom List in the menus.
Alternate Spellings: autofill, AutoFill
After typing Monday
in the first cell,
with the fill handle down over the adjacent cells. Excel will auto fill these cells with the the rest of the days of the week.