What is the absolute and relative cellreference
Answers
Answered by
1
By default, all cell references arerelative references. When copied across multiple cells, they change based on the relative position of rows and columns. For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2.
s2o8:
Example is good but I don't know minig
Answered by
2
cell reference in Excel and an absolute cell reference in Excel in this free lesson. ... There are two types of cell references: relative and absolute. ... Relative references change when a formula is copied to another cell.
Similar questions