autofill alphabet in column

[Bobby]

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

 

[JE McGimpsey]

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

 

[Ron de Bruin]

Hi Bobby

Add the alphabet in

Tools>Options...Custom lists
After you that you can enter the A and copy it down with your mouse

 

[Bobby]

As above, I really appreciate that you are willing to share your knowledge.

Thank You !!!!

 

[Bobby]

Magic!! Brilliant that you guys are out there!
Thank you