Training Snap Shot: Absolute References and Dollar Signs


    What Is Absolute Referencing?

  • A dollar sign in a formula fixes a cell reference, this is called creating an ‘absolute reference’

  • You can use an ‘absolute reference’ to keep a row and/or column constant

  • An absolute reference is designated in a formula by the addition of a dollar sign “$” before the column and row. If it is placed before the column or row (but not both), it's known as a mixed reference


  View Training Note PDF

0114 2813350 |

Copyright © 2020 | All Rights Reserved Pringle Computer systems Limited