Auto fill occurs when Excel automatically fills selected cells with data. Excel has several preset series (months of the year and days of the week) that are used with the fill handle.
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.


