|
|
|
Using AutoFill to create quick lists |
away from the cell. AutoFill examples:
 | |
 drag fill handle for list of months..................... | May, June, July |
 drag fill handle for list of days........................ | Monday, Tuesday |
 drag fill handle for list of quarters................... | QT1, QT2, QT3 |
 drag fill handle to repeat text label................. | dog, dog, dog |
 drag fill handle to repeat numerical value......... | 10, 10, 10 |
 drag fill handle for incremental list...... | 10, 20, 30 |
|
To clear an AutoFill list: select the cells that you want to clear, then drag the fill handle towards the start of the list.
To create a custom AutoFill list: choose Options from the Tools menu and click the Custom Lists tab. From the Custom lists list, select NEW LIST. Type the list pressing ENTER after each item. Click Add, then OK. |