It can be done easily with mouse clicks. For instance, in sheet 1, select a cell and start a formula by typing =. Then, click on sheet 2 in the left sidebar. Then, click on the cell in that second sheet that you want to add to the formula. This adds that cell to the formula, even though it is on a different sheet.
It can be done easily with mouse clicks. For instance, in sheet 1, select a cell and start a formula by typing =. Then, click on sheet 2 in the left sidebar. Then, click on the cell in that second sheet that you want to add to the formula. This adds that cell to the formula, even though it is on a different sheet.