This tutorial will demonstrate how to use relative references in Microsoft Excel Formulas.
For example, if you copy the formula =A1+B1 from row 1 to row 2, the formula will become =A2+B2. This is the way most users reference cells when working in a spreadsheet. If you have Sheet1, Sheet2, and Sheet3, and you use this formula on Sheet3, then it returns the value of Sheet2!A1.
When copied across multiple cells, they change based on the relative position of rows and columns. This is most handy when performing the same calculation on multiple columns or. The Fill Handle can also be used to copy formulas to. Excel table relative reference Excel uses relative references by default.
