Previous post I discussed relative cell referencing with Exercise 5.4 Here I will talk about absolute cell referencing.
Relative cell referencing is very useful in many cases by adjusting the cell references when a formula is copied from but one location to another. Example can be seen here.
There might be times that you need to use one cell in each formula. To prevent Excel to copy all cell references we use Absolute cell referencing. In Excel these formulas are constructed by placing dollar ($) signs in the cell reference.