| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Worksheet Column Labels ... Alphabet or Numeric ? | Excel Discussion (Misc queries) | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
