How to Link Cells in Google Sheets

To link cells in Google Sheets, type = in a cell and click the cell you want to link to, then press Enter. The linked cell shows the same value and updates whenever the original changes. For a cell on another tab, the formula looks like =Sales!B7. For a cell in a different spreadsheet file, use IMPORTRANGE. To add a clickable link that jumps to a cell, use Insert > Link > Sheets and named ranges.

When you need more than one mirrored cell, such as a whole block, matching rows or data from a separate file, see pulling data from another tab or file in Google Sheets.

Link to a Cell on the Same Tab

  1. Click the cell where you want the linked value.
  2. Type =.
  3. Click the source cell (or type its address, like B7).
  4. Press Enter.

Does a linked cell copy formatting?

No, only the value. Use Paint format to copy formatting.

Link to a Cell on Another Tab

  1. Type = in the destination cell.
  2. Click the other sheet tab at the bottom and click the source cell.
  3. Press Enter. The formula reads like =Sales!B7. If the tab name has spaces, it’s wrapped in quotes: =’Q3 Sales’!B7.
Spreadsheet formula bar showing a formula that links to a cell on another sheet
The linked cell updates when the source changes.

Link to a Cell in Another Spreadsheet

  1. Copy the other spreadsheet’s URL.
  2. In your sheet, type =IMPORTRANGE(“paste-URL-here”, “Sheet1!B7”).
  3. Press Enter, then click Allow access the first time.

Can I link a whole column?

Yes, for example =Sales!B:B in an array-friendly spot, or IMPORTRANGE with a column range.

Linking Options Compared

Goal Method
Show the same value =A1 or =Sheet!A1
Pull a range from another file IMPORTRANGE
Clickable jump to a cell or range Insert > Link > Sheets and named ranges
Keep a reference fixed when copying Use $, like =$B$7

To organize linked data, see how to custom sort in Google Sheets.

Fixing #REF! and Other Link Errors

  • #REF! error: The source cell or tab was deleted, or IMPORTRANGE access wasn’t allowed.
  • Reference shifts when copying: Add $ signs to lock it.
  • Value doesn’t update from another file: IMPORTRANGE refreshes periodically; wait a moment or reload.
  • Sharing the linked sheet? See making a Google Sheets file public.