1. Computing

Discuss in my forum

Customizing Excel 2003 Auto Fill Handle

Fill Handle in Excel 2003

By , About.com Guide

Customizing Auto Fill

Customizing Excel Auto Fill

© Ted French

To Add a Custom List to the Auto Fill Handle

Related Tutorials: Excel 2007 / 2010 Fill Handle Tutorials

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 Tutorials

©2013 About.com. All rights reserved.