Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

I have a series of cells referencing other cells:

 | Row |  a  |  b  | col B shows |
 |-------------------------------|
 |  1  |  1  | =a2 |      2      |
 |  2  |  2  | =a4 |      4      |
 |  3  |  3  | =a6 |      6      |

If I select cells b1,b2 & b3, then drag the autofill corner to fill in b4, b5, & b6, the fill pattern follows the increment of the "source" cells, i.e, "+2", but the autofill seems to start with a value based on the number of cells I've selected. It looks like the app takes the value of the first cell in the series ("=a2", in this case) and increments the autofill value by the number of cells selected in the series (3, here), So rather than autofilling cell b4 with the next value in the progression ("=a8"), b4 is autofilled with "=a5".

 | Row |  a   |  b   | col B shows |
 |---------------------------------|
 |  1  |  1   | =a2  |      2      |
 |  2  |  2   | =a4  |      4      |
 |  3  |  3   | =a6  |      6      |
 |  4  |  4   | =a5  |      5      |
 |  5  |  5   | =a7  |      7      |
 |  6  |  6   | =a9  |      9      |
 |  7  |  7   | =a8  |      8      |
 |  8  |  8   | =a10 |      10     |
 |  9  |  9   | =a12 |      12     |
 |  10 |  10  | =a11 |      11     |

If I select 4 cells before dragging to auto-fill, it adds "4" to "a2" and places "=a6" where I would expect it to place "=a10". Select 5 cells, I get "=a7" where I'd expect "=a12".

It looks to me like auto-fill is placing the number of values in the series (the series length) above the series increment values. I can see where this would be "by design", but I want to auto-fill my progression by a set increment, not a set series length.

Hope y'all can help! Please forgive me if I've butchered mathematical terminology :-)

share|improve this question

1 Answer 1

I think your Q is basically "I want to auto-fill my progression by a set increment" and guess that that increment is 2 and you wish to start at 2, so put 2 in one cell, 4 in the cell immediately below, select the two cells, grab the fill handle and drag down to suit.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.