Enter A,B,C,...,Z in Tools/Options/Custom Lists. You can then enter A in
A1 and drag down to A26 to fill.

In article ,
Bobby wrote:

Hi there,

Want to enter column a1..a26 alphabetically. I'm sure I can do it using fill
on the edit dropdown, but can't seem to get it to work.

Any solutions out there?

Thanks in advance