Home Excel 2002 Worksheets Custom Fill Series In Excel
Search MS Office A-Z   |   Search Web Pages/ Design A-Z

Custom Fill Series In Excel

  1. To create a custom list for Autofill:
    • Choose Tools | Options | Custom List tab. New List should be selected in the left window.
    • Click in the right window and type your list, pressing Enter after each entry.
    • Click Add.
    • Go back to the spreadsheet and type an item on the list. Drag the autofill handle to fill in the rest of the list.
  2. To enter numbers that ascent at intervals other than one:
    • Enter the first number and drag the Autofill handle with the right mouse button.
    • When you release the button, choose Series.
    • In the dialog box, enter a Step Value.