• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Getting the Most Out of Ranges > Creating a Custom AutoFill List

Creating a Custom AutoFill List

As you've seen, Excel recognizes certain values (for example, January, Sunday, 1st Quarter) as part of a larger list. When you drag the fill handle from a cell containing one of these values, Excel fills the cells with the appropriate series. However, you're not stuck with just the few lists that Excel recognized out of the box. You're free to define your own AutoFill lists, as described in the following steps:

1.
Choose Tools, Options to display the Options dialog box.

2.
Click the Custom Lists tab.

3.
In the Custom Lists box, click New List. An insertion point appears in the List Entries box.

4.
Type an item from your list into the List Entries box and press Enter. Repeat this step for each item. (Make sure that you add the items in the order in which you want them to appear in the series.) Figure 1.8 shows an example.

Figure 1.8. Use the Custom Lists tab to create your own lists that Excel can fill in automatically using the AutoFill feature.


5.
Click Add to add the list to the Custom Lists box.

6.
Click OK to return to the worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint