Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Dragging dates in Microsoft Excel...?

You know how you can drag a date and it will automatically fill out a column? Well is there a way to have those dates skip five or so lines in between automatically?

1 Answer

Relevance
  • Anonymous
    10 years ago
    Favorite Answer

    The easiest way is to type the first date into a cell, then the next date in the series into the cell below that. Select both cells at the same time and then use the autofill handle to drag them down. This will fill the series with the same gap between dates as the first two cells.

    Hope it helps.

    UPDATE - sorry, read the question wrong! If you leave the top four cells in the column empty, then type the date you want to start with in row 5. Select the top five cells (the four empty and one date cell), then use the autofill handle to drag down.

    Hope it helps.

Still have questions? Get your answers by asking now.