Auto Fill is a great way to enter sequential numbers, months or days quickly. Auto Fill looks at cells that you have already filled in and makes a guess about how you want to fill in the rest of the series. For example, if you enter January, Auto Fill will fill in the following months for you. Additionally, you can use Fill to copy formulas to adjacent cells.
If Fill doesn't enter cell content the way you expected, you can correct the content using Auto Fill Options. This button appears after using the Fill command, and it offers valuable control over how the Fill command works.
Use Auto Fill to paste a series of values.
A small Auto Fill Options button will appear at the bottom of the pasted values.
Click the Auto Fill Options button.
A list of ways you can control the cell content that is entered appears.
Select a Fill option.
The cell content is changed according to the Fill option you chose.