Suppose you enter 2, 4, 6 and then autofill. Not surprisingly, Excel gives you 8, 10, 12, and so on.

But when I try:

=A2
=A4
=A6

and autofill, hoping to get =A8, =A10, =A12, etc, I get something really weird instead. Excel gives me:

=A2
=A4
=A6
=A5
=A7
=A9
=A8
=A10
=A12
=A11
=A13
etc...



First, does anyone understand the logic behind the above pattern? Second, is there a way to achieve what I initially set out to achieve?

Thanks in advance for any input.