Microsoft Excel - How to Fill in a series of numbers, dates, or other items?

1. Select the first cell in the range you want to fill.
2. Enter the starting value for the series.
3. Enter a value in the next cell to establish a pattern.
   • If you want the series 2, 3, 4, 5..., enter 2 and 3 in the first two cells. If you want the series 2, 4, 6, 8..., enter 2 and 4. If you want the series 2, 2, 2, 2..., you can leave the second cell blank.
     
   • To specify the type of series, use the right mouse button to drag the fill handle over the range, and then click the appropriate command on the shortcut menu. For example, if the starting value is the date JAN-2002, click Fill Months for the series FEB-2002, MAR-2002, and so on; or click Fill Years for the series JAN-2003, JAN-2004, and so on.
   • To manually control how the series is created, or use the keyboard to fill in a series, use the Series command on the shortcut menu.
4. Select the cell or cells that contain the starting values.
5. Drag the fill handle over the range 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.