Question

in what referencing the reference change row and colounm automaticaly when it is copied to a new cell​

Answer 1

Answer:

Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell. Situations arise in which the cell reference must remain the same when copied or when using AutoFill.