How to Fill a Series in Excel 2007

By Carter McBride

Microsoft Office is a spreadsheet program in Microsoft's Office Suite. Microsoft Excel allows users to sort and use data to perform calculations. Microsoft Excel comes with a "fill series" function. Fill series will take a series of numbers or words and automatically enter in the next numbers or words in the series. For example, if the user has 1, 2, 3, then Microsoft Excel will fill in 4, 5, 6 and so on. This feature is useful to quickly complete series of numbers without the need for typing in each number.

Step 1

Type out a series of numbers in the cells you want the start your series. For example, type "1" in cell A1, "2" in cell A2, then "3" in cell A3.

Step 2

Click on the first number in your series, then press "Shift" and using the arrow buttons highlight the remainder of the series you typed. In the example, highlight cells A1 through A3

Step 3

Click and hold the click in the lower, right-hand corner of the highlighted cells, then move the mouse down to highlight the empty cells where you want to continue your series. In the example, click and hold on the bottom right of cell A3, then drag the mouse down to cell A6. Microsoft Excel will fill cell A4 in with "4," A5 with "5" and A6 with "6."