Forum Discussion

Claudia Smith's avatar
Claudia Smith
Copper Contributor
Sep 13, 2018

What is an"absolute reference"?

I have been asked to use an absolute reference. What does that mean?
excel
Lorenzo Kim's avatar
Lorenzo Kim
Bronze Contributor
Sep 13, 2018
I think it is about the location of a cell - a cell addressed as $A$1 instead of just A1 - will signify it's absolute location - because when you copied formula it will assume that the location will change accordingly. unless you used $A$1 - it will always be that location.
HTH
  • Lorenzo Kim's avatar
    Lorenzo Kim
    Bronze Contributor
    Sep 13, 2018
    https://www.google.com.ph/search?q=excel+absolute+reference&oq=excel+absolute+reference&aqs=chrome..69i57.5647j0j1&sourceid=chrome&ie=UTF-8

Resources