Does Excel adjusts the cell references when a formula is copied?

Answer 1

Yes, it does this as its default action.

=A1

This for example is a very simple function, if put in cell C1; this will make that cells value equal to that of A1.

If you were to copy, or drag this cell down, the row number would automatically increment (Or decrement if you were to it in reverse).

If you were to copy, or drag this cell across, the column letter would automatically increment (Or decrement if you were to it in reverse).

=$A1

Would prevent the Column from incrementing or decrementing

=A$1

Would prevent the Row from incrementing or decrementing

=$A$1

Would prevent both the Row and Column from incrementing or decrementing, forcing the cell reference to stay the same regardless of where it was copied.

Answer 2

Nothing as such. It is a a built-in feature to do that and the standard way it is done. It is one of the features that makes a spreadsheet so useful. You can instruct it not to do so, by using absolute and mixed referenced cells by using the $ sign in the cell references.

Answer 3

There is no formula that adjusts a cell reference. A cell reference identifies a unique cell. You can use the OFFSET function to a reference a range that is offset a number of rows and columns from another range or cell.

Answer 4

relative cell references

Answer 5

relative cell address

Answer 6

Relative