What is absolute reference
Answers
Answered by
7
An absolute reference is an cell reference that intentionally won't change when an formula is copied. There are many situations where absolute references are helpful. ... To make a reference absolute, you need to add dollar signs to the address, one to lock the row, and one to lock the column.
hope it helps u..mark as the brainliest
Answered by
4
HEY!!
HERE IS YOUR ANSWER :-
An absolute cell reference is a cell address that contains a dollar sign ($) in the row or column coordinate, or both. When you enter a cell reference in a formula, Excel assumes it is a relative reference unless you change it to an absolute reference
MARK AS BRAINLIST IF HELPED ^_^
Similar questions