HowtoUseAbsoluteReferences

These are references that will change with the new location of the formula. An example would be if you were to add the components of cell B2 through B7 for a total amount. You can then autofill this formula from B2 through as many columns you have,F2. The formula will go to every cell and will give you the total for every column.
 * __Relative Cell Reference__**

These are references that remain the same when a formula is copied to a new location. An example would be multiplying to cells B2 and C7, B2 being the hours, and C7 being the rate of pay, which we want to remain the same. You would need to give C7 an absolute reference. To do so you place two dollar signs before the column and row ($C$7). By making the reference to the rate of pay an absolute reference, we can use the fill button to copy the function to the other rows.
 * __Absolute Cell References__**


 * __Note:__** An easy trick to filter through all the references of a cell is pressing F4, going through these A12, $A$12, A$12, $A12.