You can quickly fill cells in a range with a series of numbers or dates, or with a built-in series for days, weekdays, months, or years by using the fill handle or the Fill command.

Fill cells with a series by using the fill handle

  1. Select the first cell in the range that you want to fill.

  2. Type the starting value for the series.

  3. Type a value in the next cell to establish a pattern.

    For example, if you want the series 1, 2, 3, 4, 5..., type 1 and 2 in the first two cells. If you want the series 2, 4, 6, 8..., type 2 and 4. If you want the series 2, 2, 2, 2..., you can leave the second cell blank.

  4. Select the cell or cells that contain the starting values.

  5. Drag the fill handle Fill handle across the range that you want to fill.

    To fill in increasing order, drag down or to the right. To fill in decreasing order, drag up or to the left.


  6. You can also specify the type of series by using the right mouse button to drag the fill handle over the range and then clicking the appropriate command on the shortcut menu. For example, if the starting value is the date JAN-2007, click Fill Months for the series FEB-2007, MAR-2007, and so on; or click Fill Years for the series JAN-2007, JAN-2008, and so on.

  7. If the selection contains numbers, you can control the type of series that you want to create.

  8. You can suppress series AutoFill by holding down Ctrl as you drag the fill handle of a selection of two or more cells. The selected values are then copied to the adjacent cells, and Excel does not extend a series.