Ask a new question

Automatically fill cells with alphabetic series

How do I fill cells with alphabetic series?  I can do this easily with numbers - enter 1, 2, 3, and drag the cell down to fill in numbers.  The same thing does not work for letters.

Is this a feature I can turn on?

Answer
Answer

If you mean you want to be able to put "A" in a cell...and drag down to create a series: A B C D ...X Y Z A B C...etc

• Put the list of letters A to Z in a column...eg in A1:A26
• Select the range of letters
• Tool.Options.Custom_Lists
...Click: Import

Now that series is available for you to use.

You can begin with any letter of the alphabet. Dragging the fill handle will continue the list.

Does that help?

Ron Coderre
Microsoft MVP (2006 - 2010) - Excel

P.S. If any post answers your question, please mark it as the Answer (so it won't keep showing as an open item.)
Regards,

Ron Coderre
Former Microsoft MVP - Excel

2 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated February 14, 2024 Views 16,145 Applies to: