In this article:

How to Reference Another Sheet in the Same Workbook on Google Sheets

May 8, 2024

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.

Cell with equal sign, where the reference shall be added.

Step 2: While you have not yet pressed Enter, click on the Sheet where the data is located, and click on the specific cell. 

The cell on another sheet selected.
As you have noticed, a floating cell appears on the window while you look for the specific cell to reference. 

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. 

The cell reference to another sheet is working.

If you copy the formula, the reference updates itself accordingly.

Formula copied to adjacent cells, cell reference still working

If you later rename the sheet being referenced, the formulas are also updated.

Sheet name changed, cell reference automatically updated to work.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->