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.