Solved

Autofill a series in Excel 2013

Posted on 2013-11-29
5
331 Views
Last Modified: 2013-11-29
This is really frustrating me and it should be simple but I must have a setting wrong somewhere that I cannot find.
I simply want to fill a column with a series but when I highlight the first two cells in the series and drag the fill it just repeats the first two cells all the way down the column.
So if I enter "a" in cell 1 and "b" in cell two and then highlight the two cells and drag the handle it fills the column as a,b,a,b,a,b,a,b,etc when I want it to fill a,b,c,d,e,f,etc
I have opened a blank workbook to test and the problem exists there also.
Strangely I also have Excel 2010 installed and the same behaviour is happening in that too.
0
Comment
Question by:Milkybar-kid
  • 2
  • 2
5 Comments
 
LVL 48

Assisted Solution

by:Rgonzo1971
Rgonzo1971 earned 150 total points
Comment Utility
Hi,

Excel cannot make series with letters

if you only want letters until z you could use this formula if a is in the first row

=CHAR(64+ROW(A1))

Open in new window


Regards
0
 
LVL 1

Author Comment

by:Milkybar-kid
Comment Utility
Wow! - I never realised that. Thank you - that has been bugging me for so long and such a simple explanation.
How can I get a lower case using your example?
0
 
LVL 31

Expert Comment

by:Rob Henson
Comment Utility
In earlier versions you could create custom lists eg letters of the alphabet, colours of the rainbow. Not sure where that option is in later versions. I will see if I can find it.

Thanks
Rob H
0
 
LVL 31

Accepted Solution

by:
Rob Henson earned 350 total points
Comment Utility
File tab - Options - Advanced - Scroll all way down to bottom and just up from the bottom there is a button to edit Custom Lists.

Thanks
Rob
0
 
LVL 1

Author Closing Comment

by:Milkybar-kid
Comment Utility
Thank you so much for the explanations. I hope the points awards are fair for the information provided.
0

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now