The fill function is a rarely used function in the home tab of excel. It can be used to fill the same data in the previous cells in all the selected cells or may also be used to fill the series in the selected cells.
That is, if we need the series of odd numbers, we should select any two members of the series and select the cells until which the numbers are to be filled.
When a series is requires, the series option is selected from the dropdown menu, and the dialgue box as aboe opens.
On clicking “OK”, the values are updated in the selected cells.
AV's Blog 