Cell references in Excel
Cell reference,
a. Relative cell reference
b. Absolute cell reference
c. Mixed cell reference
a. Relative cell reference:
When you copy the cell/cells in excel consisting formula, the formula will change/adjust according to the new cell address.
b. Absolute cell reference: (prefix $ for both row and column)
You can customize the formula in a cell in such a way that the cell reference is fixed even after copying a cell consisting formula.
F4 - short cut for absolute reference to prefix $ symbol.
c. Mixed cell reference: (prefix $ for either column or row - any one)
While copying cell consisting of formula we can keep COLUMN fixed and have the row value to be changed with respect to the new cell address.
example: $D4
While copying cell consisting of formula we can keep ROW fixed and have the column value to be changed with respect to the new cell address.
example: D$4