If I want to copy a formula from one cell to another and keep the rows references fixed while the column references change, what kind of referencing should I use?
Answers
Answered by
4
Explanation:
If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same. Place a "$" before a row number if you want that to always stay the same.
Answered by
2
Answer:
"relative" cell references, since they change relative to where you copy the formula. If you do not want cell references to change when you copy a formula, then make those cell references absolute cell references. Place a "$" before the column letter if you want that to always stay the same.
Explanation:
Similar questions