Customizing Excel 2003 Auto Fill Handle

To Add a Custom List to the Auto Fill Handle

Typing the new Auto Fill list yourself

1. Click Tools > Options in the menus to bring up the Options dialog box.
   
   
2. Click the Custom Lists tab.
   
   
3. Click in the List entries box and type in the new list, separating each element with a comma.
   
   
4. Click the Add button.

The new Auto Fill list appears in the Custom Lists window.

To import a custom Auto Fill list from your spreadsheet

1. Drag select the range of cells in your spreadsheet containing the list elements.
   
   
2. Click Tool > Options in the menus to bring up the Options dialog box.
   
   
3. Click the Custom Lists tab.
   
   
4. The range of cells you previously selected should be present in the Import list from cells box.
   
   
5. Click the Import button.

The new Auto Fill list appears in the Custom Lists window.

Using the new list with the Auto Fill Handle

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 current cell.
   
   
6. Drag the fill handle to auto fill as many cells as needed.

Related Articles

• Using Excel Auto Fill
• Customizing Excel 2007 Auto Fill Handle
• Using AutoComplete to Enter Data
  More Spreadsheets Quick Tips