Auto Fill Dates

In this topic, you will Auto Fill a series of Dates.


  1. Dates:


    Auto Filling a Sequence of Dates.

    Step 1
  2. Click in the cell.


    Step 2
  3. Type the first date in the sequence.


    In this example, enter January 1

    Step 3
  4. Hit the Enter key

    Step 4
  5. Click on the Auto Fill handle (lower right hand corner of the cell) and drag down.

    Step 5
  6. Release the mouse button.

    Step 6
  7. Results:

    Step 7

After completing this topic, you are able to Auto Fill a series of Dates.