For example, the Year column in row 1 contains the value 1980, and you want to copy it to rows 2, 3, 4, and 5.

1. Select the cell whose contents you want to copy.
2. Rest your mouse pointer on the drag fill handle at the bottom right corner of the cell.

   

3. When you see the drag cursor (+), drag until all the destination cells are included. You can drag above or below the selected cell.

   

For example, you want to fill the cells in the Quarter column with the values 1, 2, 3, 4, 1, 2, 3, 4, and so on.

1. Type 1 in the first row, 2 in the second row, 3 in the third row, and 4 in the fourth row.
2. Select all four cells.
3. Rest your mouse pointer on the drag fill handle at the bottom right corner of the selection.
4. When you see the drag cursor (+), hold down CTRL and drag until all the destination cells are included. You can drag above or below the selected cell.

For example, you want to fill the cells in the Year column with the values 1910, 1920, 1930, and so on.

1. Type 1910 in the first row, and 1920 in the second row.
2. Select the Year cell of the first and second rows.
3. Rest your mouse pointer on the drag fill handle at the bottom right corner of the selection.
4. When you see the drag cursor (+), drag until all the destination cells are included. You can drag above or below the selected cell.

Note  If the initial series contains a single value, you must hold down CTRL while dragging the fill handle to generate a series.

Examples of linearly increasing values