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

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 <2F97C1A3-A06D-4E48-8A3B-5328526C7B85@microsoft.com>,
Bobby <Bobby@discussions.microsoft.com> 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

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" <Bobby@discussions.microsoft.com> wrote in message news:2F97C1A3-A06D-4E48-8A3B-5328526C7B85@microsoft.com...
> 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

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" <Bobby@discussions.microsoft.com> wrote in message news:2F97C1A3-A06D-4E48-8A3B-5328526C7B85@microsoft.com...
> > 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
>
>
>

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 <2F97C1A3-A06D-4E48-8A3B-5328526C7B85@microsoft.com>,
> Bobby <Bobby@discussions.microsoft.com> 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
>