Skip to main content

Cell Reference in Excel.

 What is Cell Referencing?

Cell referencing in Excel refers to the method of identifying and using specific cells or ranges of cells within a worksheet in formulas and functions to perform calculations or retrieve data.




There are three types of Cell Referencing in Excel:

  1. Relative Reference
  2. Absolute Reference
  3. Mix Reference

  1. Relative Referencerelative reference is a way of referring to a cell in a formula, where the reference changes when you copy the formula to other cells.

    For example: Suppose In Column A, B, C there is Product Name, Price, Quantity relatively till 10 row. Now I want to calculate the Total Price by multiplying Price and Quantity.

Comments

Anonymous said…
It is really amazing and easy way to explain Cell Referencing. Thank to make it easy.