Question
What is absolute referencing in Excel?
Answer
In case, if you wish to maintain the original references as they were, then you should make use of the absolute references. If you want to make the above example retain the original reference when it is copied, then you should precede the columns A2 and B2 and the row number by a Dollar ($) symbol. i.e., you should use the formula as =$C$2+$B$2 so that when you copy the formula the original reference is retained.
To make the cell appear in absolute format ($) click on the cell you would like to edit and press [F4] and press enter. You will observe the cell A1 turn into =$A$1.
For example, if you copy or fill an absolute reference in cell B2 to cell B3, it stays the same in both cells =$A$1.
For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3
If you need further assistance, please click the CTL Support Request button on this page