N
Common Ground News

How do you reference a sheet in Google Sheets?

Author

Penelope Carter

Updated on March 02, 2026

How do you reference a sheet in Google Sheets?

Get data from other sheets in your spreadsheet
  1. On your computer, go to docs.google.com/spreadsheets/.
  2. Open or create a sheet.
  3. Select a cell.
  4. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1! A1 or ='Sheet number two'! B4 .

Thereof, how do I reference a sheet in Google Sheets?

Get data from other sheets in your spreadsheet

  1. On your computer, go to docs.google.com/spreadsheets/.
  2. Open or create a sheet.
  3. Select a cell.
  4. Type = followed by the sheet name, an exclamation point, and the cell being copied. For example, =Sheet1! A1 or ='Sheet number two'! B4 .

Additionally, how do I pull data from one sheet to another in Google Sheets? Import data from another spreadsheet

  1. In Sheets, open a spreadsheet.
  2. In an empty cell, enter =IMPORTRANGE.
  3. In parenthesis, add the following specifications in quotation marks and separated by a comma*: The URL of the spreadsheet in Sheets.
  4. Press Enter.
  5. Click Allow access to connect the 2 spreadsheets.

In respect to this, can you reference another Google sheet?

Google Spreadsheets lets you reference another workbook in the spreadsheet that you're currently editing by using the ImportRange function. ImportRange lets you pull one or more cell values from one spreadsheet into another. To create your own ImportRange formulas, enter =importRange(spreadsheet-key, range).

How can I get Google sheets to auto update a reference to another sheet?

In both spreadsheets insert an =importrange() function that references the now function of the other spreadsheet. Go into your spreadsheet settings and choose to recalculate on every minute.

It's common that you need to link data between tabs (sheets) in a Google Sheets file. Once you press Enter, Sheets will take you back to where you started the formula, and you'll see the data from the linked cell. Now, you're linked to the cell on the second sheet. If the source cell changes, so will the linked cell.

How do I reference a cell in another worksheet?

To reference a cell or range of cells in another worksheet in the same workbook, put the worksheet name followed by an exclamation mark (!) before the cell address. For example, to refer to cell A1 in Sheet2, you type Sheet2! A1.

What does Unresolved sheet name mean?

If the formulas do not have an existing tab in the destination spreadsheet to refer to, you will get the following message. Unresolved sheet name 'Master' So it is important that the tab in the destination spreadsheet exists and has the correct names prior to copying the tabs across from the source spreadsheet.

What is indirect function in Google Sheets?

The INDIRECT function in Google Sheets takes in the cell address in the form of text and returns a cell reference. It works in the opposite way to the ADDRESS function, which returns an address in text format.
Link Spreadsheet Cells with !

Just enter =Names! B3 in any cell, and you'll get the data from that cell in your new sheet. Or, there's an easier option. Type = in your cell, then click the other sheet and select the cell you want, and press enter.

In a Google Sheet: Go to Insert link (Ctrl-K) Specify or select the desired range. Click Apply.

Link to cell ranges in Google Sheets

  1. Tips.
  2. Sheets.
  3. Link to cell ranges in Google Sheets.

How do I set permissions in Google Sheets?

Sharing a Google Sheet
  1. Click the green "Share" button in the upper right corner of the Google Sheet.
  2. Type the email address for the person with whom you'd like to share the sheet and assign permissions from the drop down to the right.
  3. Optionally, add a note and make sure the "Notify people" box is checked.
To link to cells in your spreadsheet, simply go to "Insert link" > "Select a range of cells to link" and type or highlight the desired range.

How do I auto populate a Google sheet?

Use autofill to complete a series
  1. On your computer, open a spreadsheet in Google Sheets.
  2. In a column or row, enter text, numbers, or dates in at least two cells next to each other.
  3. Highlight the cells. You'll see a small blue box in the lower right corner.
  4. Drag the blue box any number of cells down or across.

How do I automatically update data from one spreadsheet to another?

Two methods of linking data in different worksheets
  1. Copy and Paste Link. From source worksheet, select the cell that contains data or that you want to link to another worksheet, and copy it by pressing the Copy button from the Home tab or press CTRL+C.
  2. Enter formula manually.

How do you automatically update cells in Google Sheets?

How to Update Your Data In Google Spreadsheet Automatically (from Database)
  1. Step 0: Sign up & connect data sources to Holistics. If you don't currently have an account, sign up here and start connecting your SQL databases to Holistics.
  2. Step 1: Create a report.
  3. Step 2: Setup Scheduled Export to Google Sheets.
  4. Step 3: Done.

Related Documentation

What causes white light dispersal?

What area of London is Harrods?

Are pc3 and ddr3 the same?

How do you reference a sheet in Google Sheets?