odd
Presume you mean '=A1+1' etc, ie equals sign in there. Does the 'fill' command work (from memory rhs of home toole bar. Pick series with increment as 1.
Other than that , no '$' signs in the formula ? Cells formatted as 'general' or number with appropriate significant places ?