what is the difference between absolute and mixed cell references
Answers
Answered by
1
When a formula contains relative referencing and it is copied from onecell to another, Excel does not create an exact copy of the formula. Both the column and row of both cells areabsolute and will not change when copied. Mixed referencing can also be used where only the row OR column fixed.
Answered by
3
When a formula contains relative referencing and it is copied from one cell to another, Excel does not create an exact copy of the formula. ... Both the column and row of both cells are absolute and will not change when copied. Mixed referencing can also be used where only the row OR column fixed.
Similar questions