autofill alphabet in column
 

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
--
Bobby

autofill alphabet in column
 

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

autofill alphabet in column
 

Hi Bobby

Add the alphabet in

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bobby" wrote in message ...
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
--
Bobby

autofill alphabet in column
 

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

Thank You !!!! :-)
--
Bobby


"Ron de Bruin" wrote:

Hi Bobby

Add the alphabet in

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

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bobby" wrote in message ...
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
--
Bobby

autofill alphabet in column
 

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


"JE McGimpsey" wrote:

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