PC Review


Reply
Thread Tools Rate Thread

autofill alphabet in column

 
 
=?Utf-8?B?Qm9iYnk=?=
Guest
Posts: n/a
 
      9th Aug 2006
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
 
Reply With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      9th Aug 2006
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-(E-Mail Removed)>,
Bobby <(E-Mail Removed)> 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

 
Reply With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      9th Aug 2006
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" <(E-Mail Removed)> wrote in message news:2F97C1A3-A06D-4E48-8A3B-(E-Mail Removed)...
> 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



 
Reply With Quote
 
=?Utf-8?B?Qm9iYnk=?=
Guest
Posts: n/a
 
      9th Aug 2006
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" <(E-Mail Removed)> wrote in message news:2F97C1A3-A06D-4E48-8A3B-(E-Mail Removed)...
> > 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

>
>
>

 
Reply With Quote
 
=?Utf-8?B?Qm9iYnk=?=
Guest
Posts: n/a
 
      9th Aug 2006
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-(E-Mail Removed)>,
> Bobby <(E-Mail Removed)> 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

>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why can't I autofill the alphabet? =?Utf-8?B?VEhTYWxkaXZhcg==?= Microsoft Excel Misc 2 1st Jul 2006 03:08 AM
Autofill alphabet series not possible in Excel? abqhusker Microsoft Excel Worksheet Functions 1 25th Jun 2004 06:11 PM
Excel - Return column alphabet from column number Sathyaish Microsoft Excel Programming 2 7th Apr 2004 03:40 PM
Excel - Return column alphabet from column number Sathyaish Microsoft Excel New Users 2 7th Apr 2004 03:40 PM
Excel - Return column alphabet from column number Sathyaish Microsoft Excel Misc 2 7th Apr 2004 03:40 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:41 PM.