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
- 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.
- 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.