For example, if a simple addition formula in cell C1 “=(A1+B1)” is copied to cell C2, the formula would change to “=(A2+B2)” to reflect the new row. It will change cell addresses relative to the row and column they are moved to.
When a formula contains relative referencing and it is copied from one cell to another, Excel does not create an exact copy of the formula. Relative referencing is the practice of calling cells by just their column and row labels (such as “A1”). Relative, Absolute, and Mixed Referencing This formula would of course be entered inside Sheet2 of Book2.xlsx.
Similarly, suppose Worksheet 1 was in a workbook named Book1.xlsx, and Worksheet 2 was in a workbook called Book2.xlsx, the same cells could be added using the formula “=Sheet1!$A$1+A2”. For example, the value of cell A1 in Worksheet 1 and cell A2 in Worksheet 2 can be added using the formula “=A1+Sheet2!A2”. The base formula is written as “sheetname!celladdress” when linking cells from different workbooks. The base formula is written as “sheetname!celladdress” when linking cells from worksheets within the same workbook. This can be done within the same workbook or across different workbooks. You can create a formula that uses data from two different worksheets.
