Adding a Series of Numbers with the Fill Handle

Excel 2007 Fill Handle

You can use the fill handle to add a series of numbers to an Excel spreadsheet.

To do so, you need to enter enough data to show Excel the pattern - such as counting by two's that you want to use.

Once you have done this, the fill handle can be used to repeat the series as often as needed.

Example Using the Fill Handle to Add a Series of Data:

Note: For help with this example, see the image to the right.

1. Type the number 2 in cell D2 and press ENTER on the keyboard.
   
   
2. Type the number 4 in cell D3 and press ENTER on the keyboard.
   
   
3. Drag select cells D2 and D3 to highlight them.
   
   
4. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the cell D3.
   
   
5. Drag the fill handle down to cell D6.
   
   
6. Cells D2 to D6 should contain the numbers : 2, 4, 6, 8, 10.
   
   

Related Articles

• Customizing Excel 2007 Auto Fill Handle
• Copy Formulas with the Fill Handle
• Adding Data with the Auto Fill Handle