Alphabetical autolists

[Gabriele Azzaro]

Hi there. Is there a simple way of getting Excel 2002 create alphabetical
autolists, say from A to ZZZ, like Quattro Pro does? Creating a custom
autlist is just too long for more than a few dozen items.

Thanks for any help.

Gabriele

 

[William]

Hi Gabriele

1) Manually create the list you want to use as an autolist (if not created
already).
2) Select "Tools>Options>Custom Lists"
3) Click the "Add" button and place your cursor in the box "Import List from
Cells"
4) Select the list on the worksheet and click "OK"

To create the list in future, enter the first few items and then drag down -
Excel will create the list for you.

--
XL2002
Regards

William

(e-mail address removed)

| Hi there. Is there a simple way of getting Excel 2002 create alphabetical
| autolists, say from A to ZZZ, like Quattro Pro does? Creating a custom
| autlist is just too long for more than a few dozen items.
|
| Thanks for any help.
|
| Gabriele
|
|