This used to work in MS Excel and I can't figure out why it doesn't anymore...

I have a column of numbers say 1-15 vertically.

I begin a second column and create a formula that directs the first value of
the second column to equal the first value of the first column (1).

I then highlight the formula cell and the cell beneath it and use autofill
to drag both down to create a column with the same numbers as the first
except with rows of spaces between the formulas. 1, 2, 3, 4, 5, etc.

The above procedure does not work anymore. I now get a column that has
formulas in every other row but the formulas reference every odd value
instead of each value. So the column reads 1, 3, 5, 7, 9 etc.

This must be an options issue but I can't seem to locate it.