.png)
How to Reference Another Sheet in the Same Workbook on Google Sheets
Easy step-by-step tutorial on how to reference cell(s) from another sheet in the same Google Sheets workbook! Useful for organizing large amounts of data.
It so often occurs that you have to create another sheet in the same Google Sheets workbook to keep the data neat and clean. The procedure is simple. Here are the steps:
Step 1: Type = on the cell where you want the data to appear.
Step 2: While you have not yet pressed Enter, click on the Sheet where the data is located, and click on the specific cell.
Step 3: Press Enter.
If you check the formula in the cell, the reference begins with the name of the sheet followed by an exclamation point symbol, and then the cell location follows. You can type them in that form, and the formula would still work.
If you copy the formula, the reference updates itself accordingly.
If you later rename the sheet being referenced, the formulas are also updated.
