Difference between absolute and relative reference : 3 Types of cell references

Difference between absolute and relative reference

In normal excel use, we are facing issues with cell values when we are copying a cell from one place to another place. It happens due to references used in the cell. Usually, there are two cell references in excel 1) absolute reference and 2) relative reference. We also use mixed references. Let’s understand it in detail.

Relative References

BY default every cell reference is the relative reference. When copied across cells the values also change relatively.

Difference between absolute and relative reference in Excel
Relative Reference in excel

In the above example, we can see that we first refer to value in CELL B3 and when we copied it to cell E3 the cell reference got changed from cell … Continue Reading