I have a simple spreadsheet with just one formula, which auto-increments the number in the first column, going from cell A6 down. So the value in A6 is hard-coded 1, then A7 contains the formula =A6+1. I then autofilled the rest of the first column with that formula, and sure enough each cell in column A has the formula, and the displayed numbers are 1, 2, 3, etc.

But if I select a row and move it up or down by Shift-dragging, the formula in cell A disappears and is replaced with the hard-coded former contents. WHY? I can find nothing in the preferences to explain this major dysfunction.

This is Excel 2011 on Mac.

Thanks for any insight!

Update: So I guess Excel is just fundamentally broken, at least on the Mac.

`=ROW()-5`

instead. – Kyle Nov 25 '15 at 15:50