Home -> Number ->Format Cells Fill a Series with AutoFill Now, one way to put in the dates for the next month would be to type them all. Do you want to know a faster way? AutoFill is a quick method for filling in data. It is not quite the same as copy and paste.   5. Try This: Use The AutoFill Please select Cell A2, first. Look at the bottom right corner of Cell A2. The AutoFill Handle is a black square. When you run your mouse over the Handle, your mouse will become a thin black cross.   Hold the AutoFill handle and drag down to Row 20.   What Do You See? The dates will increment (add another day to each Row) as you Fill Down Cell A2.   Keep going...