Here i will show you Cell Reference: How to Use Relative, Absolute, and Mixed Cell References in MS Excel Bangla.
In order to keep accurate formulas, it is necessary to understand that how cell references work when you copy or fill formulas or function to new cells in the worksheet.
You will get interested cell references as either relative or absolute. By default, cell references are relative references. When copied or filled, they change based on the relative position of rows and columns….