Sometimes you need to enter a lot of repetitive information in Excel, such as dates, and it can be really tedious. But AutoFill can help.
Type the first date in the series.
Put the mouse pointer over the bottom right-hand corner of the cell until it’s a black plus sign.
Click and hold the left mouse button, and drag the plus sign over the cells you want to fill. And Excel fills in the series for you automatically using the AutoFill feature.