Auto Fill Feature In Excel. Select one or more cells you want to use as a basis for filling additional cells. It helps to fill subsequent data automatically when we drag the selected cell corners.
This little option gives you plenty of possibilities. And the series is filled in for you automatically using the autofill feature. Tap the cell containing the initial value in the series you want autofill to extend.
Click and hold the left mouse button and drag the plus sign over the cells you want to fill.
In the editing section of the home tab click fill and then select series. We can use autofill in excel for numbers sides east west north and south years dates months and some other types of data. In excel 2019 2016 2013 and 2010 navigate to the file options menu. In microsoft excel autofill is a feature that allows the user to extend a series of numbers dates or even text to the necessary range of cells.
