Every time you use Excel formula will involve cell references, but we often just a direct reference and ignore the reference behind the knowledge, share with you today, the relative references in the cell reference, absolute reference.
Relative Reference Example: A1
Meaning: Drop-down padding becomes reference A2, A3, A4, right-hand padding becomes reference B1, C1, D1
Example of a formula reference:
Absolute reference
Example: $ A $ 1 (refer to cell A1 and press F4 to adjust the reference mode)
Meaning: drop-down padding, right-padding are referenced A1 cells (that is, padding, column references are not changed)
Example of a formula reference:
Column relative reference, the line absolute reference
Example: A $ 1
Meaning: reference A1 when filling down, reference B1, C1 and D1 when filling in right (ie, the filling line remains the same)
Example of a formula reference:
Column absolute reference, the line relative reference
Example: $ A1
Meaning: Reference A2, A3, A4 for pulldown, Reference A1 for fill right (ie the column will remain unchanged when filled)
Example of a formula reference:
