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

3 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Sep 13, 2018

    Hi,

     

    I think this https://www.youtube.com/watch?v=51JdnRuR4VY would be very helpful to you!

     

    Hope that helps

  • 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