The fastest way to link cells across sheets

To link a cell from one sheet to another in Excel, type an equals sign, then the sheet name, an exclamation point, and the cell reference. For example, =Sheet2!A1 pulls the value from cell A1 on Sheet2 into your current sheet. When the source cell changes, the linked cell updates automatically.

The sheet name matters. If your sheet is named "Sales Data" with a space, wrap it in single quotes: ='Sales Data'!A1. If the name has no spaces, quotes are optional but harmless.

You can also build the link by clicking. Type the equals sign, click the sheet tab at the bottom, then click the cell you want. Excel writes the formula for you. This method prevents typos and works the same way whether sheets are in the same workbook or different files.

Key Takeaways

  • Link cells between sheets by typing =SheetName!CellReference, where SheetName is the tab name and CellReference is like A1 or B5.
  • Sheet names with spaces must be wrapped in single quotes: ='Sheet Name'!A1.
  • Linked cells update automatically when the source cell changes, so you do not need to refresh manually.
  • You can link to cells in other workbooks, but the path breaks if you move or rename the source file.
  • Use absolute references ($A$1) if you plan to copy the formula to other cells and want it to always point to the same source.

Linking a range of cells instead of a single cell

To pull an entire range from another sheet, use the same syntax but specify the range. Type =Sheet2!A1:A10 to link cells A1 through A10. The linked range appears in your current sheet in the same layout as the source.

If you want the range to expand automatically when new data is added to the source sheet, use the INDIRECT function combined with COUNTA. For example, =INDIRECT("Sheet2!A1:A"&COUNTA(Sheet2!A:A)) pulls all non-empty cells in column A from Sheet2. This is more complex but saves you from manually updating the range later.

For most everyday work, a fixed range like A1:A10 is simpler and faster. Use dynamic ranges only if the source data grows regularly and you need the link to follow it.

Linking to cells in a different Excel file

To link to a cell in another workbook, the syntax is =[FilePath]SheetName!CellReference. The file path goes in square brackets. For example, =[C:\Users\Documents\Sales.xlsx]Sheet1!A1 links to cell A1 on Sheet1 in the Sales.xlsx file.

The source file must be open when you create the link, or Excel cannot find the cell. After you save, you can close the source file. When you reopen the file with the link, Excel will ask whether to update the links. Click "Update" to refresh the values.

Be careful: if you move or rename the source file, the link breaks. Excel will show an error or the last known value. To fix it, go to Data tab, click Edit Links, select the broken link, and update the file path. This is why linking within the same workbook is usually safer than linking across files.

Using absolute and relative references in linked formulas

When you link to a cell, Excel treats it like any other cell reference. If you use =Sheet2!A1 and copy the formula down, it becomes =Sheet2!A2, then =Sheet2!A3, and so on. This is a relative reference, and it moves with the copy.

If you want the link to always point to the same cell no matter where you copy it, use an absolute reference: =Sheet2!$A$1. The dollar signs lock the row and column. Now when you copy the formula, it stays =Sheet2!$A$1 everywhere.

You can also lock only the row or only the column. =Sheet2!$A1 locks the column but lets the row change, so copying down gives you A2, A3, and so on. =Sheet2!A$1 locks the row but lets the column change. Choose based on how you plan to copy the formula.

Troubleshooting broken links and circular references

If a linked cell shows #REF!, the source sheet or cell no longer exists. Check that the sheet name is spelled correctly and the cell reference is valid. If you renamed the source sheet, update the formula to match the new name.

If you see #NAME?, Excel did not recognize the sheet name. This usually means the name has a space and is missing quotes. Change =Sales Data!A1 to ='Sales Data'!A1 and the error clears.

A circular reference happens when a cell links to itself, directly or through a chain of other cells. Excel will warn you when you create one. To find it, go to the Formulas tab and click Error Checking, then Circular References. Fix it by breaking the chain — remove the link that points back to the original cell.

When to use links versus copying values

Use a link when the source data changes and you want the linked cell to update automatically. A sales dashboard that pulls numbers from a data entry sheet is a good example. The link stays live as long as both sheets exist in the same workbook.

Copy the value instead if the data is static or if you need to send the file to someone else. Links break when files are moved or renamed, so a standalone report with copied values is more portable. To convert a link to a value, copy the cell, right-click, choose Paste Special, and select Values.

Links also slow down large workbooks slightly because Excel recalculates them whenever the source changes. If you have hundreds of links across multiple files, consider whether you could consolidate the data into a single sheet instead.

Frequently Asked Questions

Can I link to a cell on a sheet that is hidden?

Yes. Hidden sheets work the same way as visible ones. Type the sheet name in the formula even if you cannot see the tab. If you need to unhide the sheet later, right-click the sheet tab area and select Unhide.

What happens to the link if I delete the source sheet?

The linked cell shows #REF! error. You cannot undo this by restoring the sheet unless you undo the deletion immediately. If the sheet is gone, you must either recreate the sheet or delete the formula and enter a static value instead.

Can I link to a named range instead of a cell reference?

Yes. If the source sheet has a named range called "SalesTotal", you can link to it with =Sheet2!SalesTotal. Named ranges make formulas easier to read and more flexible if the source range moves later.

Do linked cells update when the source file is closed?

No. Links to other workbooks only update when both files are open. When you reopen the file with the link, Excel asks whether to update. Choose Update to refresh the values from the source file.

How do I copy a formula with a link without changing the sheet reference?

Use an absolute reference for the sheet name by typing =Sheet2!$A$1. The dollar signs lock both the column and row, so the formula always points to the same cell no matter where you copy it. If you want only the row or column to stay fixed, use $A1 or A$1 instead.