Question

How can we create reference to the other sheets?​

Answer 1

Answer:

Create a cell reference to another worksheet

Click the cell in which you want to enter the formula. , type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.

Answer 2

$\huge\mathfrak{Answer}$

• Click the cell in which you want to enter the formula. , type = (equal sign) and the formula you want to use. Click the tab for the worksheet to be referenced. Select the cell or range of cells to be referenced.