Link Different Sheets in Excel with Formulas

To link a cell on one Excel sheet to a cell on another, enter a reference such as =Sheet2!A1 in the destination cell; Excel will show the source cell’s value and update it when that value changes. For a sheet name containing spaces, enclose the name in apostrophes, as in ='January Sales'!B2. You can also create a clickable link that takes you to another sheet without displaying its cell value.

What You’ll Need

An Excel workbook with the source sheet and the sheet where you want the linked result to appear.
The name of the source sheet and the address of the cell or range you want to reference.
For a navigation link, the destination sheet name and, optionally, a cell address to jump to.

These instructions are for Excel for Microsoft 365 on Windows. The same cell-reference method works in Excel for Mac and Excel for the web, though ribbon labels and link dialogs can differ slightly. Save the workbook before making extensive changes, particularly if it contains important data.

Step-by-Step

Identify the source and destination. Open the workbook and locate the sheet that contains the information you want to use. Note its tab name and the cell address, such as A1 or D12. Then choose the destination sheet and click the cell where the linked result should appear. For example, you might bring a monthly total from an April sheet into a Summary sheet. The source cell remains where it is; the destination cell displays a reference to it.
Enter a basic sheet reference. If the source is cell A1 on a sheet named Sheet2 and the destination is cell B2 on Summary, select Summary!B2 and type =Sheet2!A1, then press Enter. The formula begins with an equals sign, followed by the sheet name, an exclamation mark, and the source cell address. Excel displays the current value from Sheet2!A1 in Summary!B2. If A1 is blank, the linked destination will usually appear blank as well.
Build the reference by clicking instead of typing. This is helpful if a sheet has an unusual name or you are unsure of the cell address. Select the destination cell and type an equals sign. Click the source sheet’s tab, click the cell to link, and press Enter. Excel creates the reference for you. If the source cell is on a sheet named April Data and is C5, the resulting formula will be ='April Data'!C5. The assumed layout here is a destination cell on Summary and the source value in April Data!C5.
Use apostrophes around sheet names with spaces or punctuation. Sheet names such as Annual Report need apostrophes in a typed formula. With the destination cell on Summary and the value to retrieve in Annual Report!B4, enter ='Annual Report'!B4. Excel generally adds the apostrophes automatically when you create the reference by clicking. Sheet names without spaces, such as Data, can be written without them: =Data!B4. Apostrophes are part of the reference syntax, not part of the sheet’s displayed name.
Copy a link to other rows or columns when appropriate. If each row on Summary should show the matching row from a source sheet, enter a reference in the first destination row and use the fill handle (the small square at the lower-right corner of the selected cell) to copy it. For example, with source values in Data!A2:A10 and destination cells in Summary!B2:B10, begin in Summary!B2 with =Data!A2. When filled down one row at a time, the reference changes to A3, A4, and so on. Check the last few results after filling to confirm the rows still correspond.
Keep a source address fixed when copying, if needed. By default, Excel adjusts a reference as you copy it. If every destination cell should point to the same source cell, use dollar signs to make the reference absolute. Assuming the fixed value is in Rates!B2 and the first destination is Summary!C2, enter =Rates!$B$2. Copying that formula will keep the reference on B2. You can also lock only the row or column, but for most simple sheet-to-sheet links, either a fully relative or fully absolute reference is easier to check.
Link a calculation across sheets. A formula can use a source sheet’s cells as inputs, rather than merely echoing one cell. For example, if January, February, and March are adjacent tabs in that order, and each month’s total is in B2, a Summary cell can add those three values with =SUM(January:March!B2). The formula assumes the three named sheets are arranged consecutively and that the value to include is in B2 on each. If you insert another sheet between January and March, Excel includes it in the 3-D reference too, so check which tabs fall within the range.
Create a clickable link for moving between sheets. A formula reference displays data; a hyperlink is for navigation. Select the cell that should act as the link, press Ctrl+K on Windows, and look for the option labelled Place in This Document in the link dialog. Select the target sheet, enter a cell reference if the dialog offers one, and set the text to display, such as Go to Details. Confirm with OK. On Mac, use Command+K or choose Insert > Link; dialog options can vary by Excel version. In Excel for the web, use Insert > Link and check whether the dialog offers a workbook location or sheet destination.
Test the result and save. Change the source value temporarily, then confirm that the linked cell reflects the change. For a navigation link, click it and verify that Excel opens the intended sheet and location. Restore any test value, review the destination cells for errors, and save the workbook. If you share the file, keep the source and destination sheets in the same workbook when possible; that avoids broken links caused by moving or renaming a separate file.

Common Mistakes

Leaving out the exclamation mark. The sheet name and cell address need an exclamation mark between them. A reference such as =DataA1 does not identify Data!A1.
Typing a sheet name with spaces without apostrophes. A name such as Sales Data should be enclosed in apostrophes in a typed formula. Selecting the sheet and cell while building the formula helps Excel format it correctly.
Confusing a data reference with a navigation link. A formula shows a value in the destination cell; it does not take you to the source sheet when clicked. Use Insert > Link when the goal is to navigate.
Copying a relative reference without checking it. Excel adjusts cell addresses as formulas are filled. That is useful for matching rows, but can point to an unintended cell if every row should use one fixed input. Use dollar signs for a fixed address.
Renaming or deleting a referenced sheet. Excel often updates references when you rename a sheet inside the workbook, but deleting a referenced sheet can leave a broken reference. Check linked formulas after reorganizing tabs.
Expecting a blank source to behave like zero in every situation. A direct link to an empty cell can display as zero in some formula contexts. If blank-versus-zero matters, decide how the destination should behave and test the case with an empty source.

Tips

Use clear, consistent sheet names such as 2026 Sales or Lookup Table. Descriptive tabs make formulas easier to read and reduce the chance of choosing the wrong source.
Use the point-and-click method for your first reference, especially when sheet names contain spaces. It is usually quicker than correcting a mistyped reference.
Keep summary formulas together on a summary sheet, and label the linked outputs so other people know what they represent. A linked number without a heading can be hard to interpret later.
For a long list of links, test one formula first, then copy it and inspect the beginning, middle, and end of the filled range. This catches shifted rows and accidental fixed references.
Use a hyperlink when readers need to jump to supporting detail, and a formula when they need to see or calculate with the source value. These methods can be used in the same workbook for different purposes.
If you use a 3-D reference across several tabs, keep the included sheets next to one another and document the range. Moving a tab into or out of that span can change the calculation.

Troubleshooting

The cell shows #REF!. This usually means the reference no longer points to a valid cell or sheet, often because a source sheet or cell was deleted. Edit the formula, select the correct sheet and cell, and press Enter. If the link refers to another workbook, confirm that the source file has not been moved or renamed.

The formula appears as text instead of calculating. Check whether the cell is formatted as Text or whether the formula begins with an apostrophe. Change the cell format to General, edit the formula, and press Enter. Also check that calculation is enabled under Formulas > Calculation Options > Automatic in desktop Excel.

The result is wrong or from the wrong row. Click the destination cell and inspect the formula bar to see the exact sheet and address. Verify the row and column, then check whether copying changed the reference. If the value should always come from one location, add dollar signs to lock its address.

The value does not seem to update. Check that the formula points to the cell you edited, and confirm calculation is set to Automatic. Press F9 to recalculate in Windows if necessary; on Mac, use fn+F9 on keyboards where function keys control system features. If the source is in another workbook, open or update that workbook link when Excel prompts you.

The hyperlink does not jump to the right place. Reopen the link settings and select the intended sheet and cell. Make sure you created an in-workbook destination rather than a web address or file path. If the current Excel dialog does not show a Place in This Document option, use the available workbook-location controls or create a formula reference for displaying the value instead.

Frequently Asked Questions

Do linked cells update automatically?
Normally, yes. A formula reference recalculates when its source changes, provided Excel calculation is set to Automatic. A hyperlink does not display or track the source value; it only provides a route to a location.

Can I link a whole sheet to another sheet?
A cell formula links one cell at a time. You can copy a formula across or down to create a matching set of links, or use a range-based calculation where suitable. Check the resulting references because Excel adjusts relative addresses during copying.

Can I link to a different workbook?
Yes. With both workbooks available, start a formula in the destination workbook, select the source cell in the other workbook, and press Enter. Excel creates an external reference. Keep the source file accessible, and review update prompts if it is moved, renamed, or shared with others.

Can I link to a specific cell on another sheet?
Yes. A cell reference includes both the sheet and the address, such as Data!C7. For navigation, specify the sheet and cell in the hyperlink dialog when those options are available. A formula displays the value at that address; a hyperlink takes you there.

Why does my formula show zero when the source is empty?
Excel can display an empty referenced cell as zero, depending on the formula and workbook settings. Check that the source cell is truly empty rather than containing a space or a formula that returns an empty string. If you need a different display, adjust the formula or presentation to match how you want blanks handled.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.