به روز

Excel recognizes certain values such as January, Sunday,

Quarter 1 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 limited

to the few lists that Excel recognized out-of-the-box. Instead, you’re free to define your

own AutoFill lists, as described in the following steps:

1. Select F ile, Opt i ons to display the Excel Options dialog box.

2. Click Advanced and then click Edit Cust o m Lists to open the Custom Lists dialog box.

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

box.

4. Type an item from your list into the List E ntries 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.)

5. Click A dd to add the list to the Custom L ists box.

6. Click OK and then click OK again to return to the worksheet.

good luck