Once you have the list from a-z on your worksheet, go to ToolsOptionsCustom
Lists and "Add" the a-z to the lists.

In future just enter a in A1, b in A2 then drag/copy down.


Gord Dibben MS Excel MVP

On 1 May 2006 09:15:23 -0700, "vezerid" wrote:

Assuming you start your letters in C2, you can use:

=CHAR(65+ROW()-ROW($C$2))

Ascii codes 65-90 give A-Z and codes 97-122 give a-z.

HTH
Kostis Vezerides