Cell references in Excel are very important. In this article we will learn difference between absolute cell reference & relative cell reference in excel & then learn how to change an absolute reference to a relative reference or vice versa in Microsoft Excel 2010. When a formula is copied, a Relative reference is used. Excel Relative reference is the distance in rows and columns between the reference and the cell that contains the formula.
We use the excel absolute reference shortcut F4 key.
Let’s take an example to understand how we can change the relative cell reference from absolute cell reference and absolute to relative.
We have data in the range A4:F9 in which column A contains subjects and range B4:F9 contains the score of the students. Cell A1 contains the total marks. We need to calculate the percentage of students’ scores.
In this case, we define the cell A1 as absolute reference.
Absolute reference to the column and row and Relative reference to the Column and Row
Follow below given steps:-
This is the way by which we can use the Absolute references and relative references in our formulae by using the key F4 in Microsoft Excel 2010 and 2013.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.