Adding Data with the Fill Handle

If you have added lists of custom data to the fill handle, this tip explains how easy it is to add that data to your spreadsheet.

1. Click on the cell where you want the list to start.
   
   
2. Type in the first name in the list.
   
   
3. Press the ENTER key on the keyboard.
   
   
4. Click on the cell containing the first name in the list.
   
   
5. Click and hold down the mouse pointer on the fill handle in the bottom right corner of the active cell.
   
   
6. Drag the fill handle to auto fill as many cells as needed.

Related Articles

• Customizing Excel 2007 Fill Handle
• Copy Formulas with the Fill Handle
• Adding a Series of Numbers with the Fill Handle