Autofill a series in Excel 2013
Posted on 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.