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

[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.

In article <[email protected]>,
Bobby <[email protected]> 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

[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

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



"Bobby" <[email protected]> wrote in message news:[email protected]...
> 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

[Bobby]

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
>
> Tools>Options...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" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>

[Bobby]

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 <[email protected]>,
> Bobby <[email protected]> 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
>