How to Link Excel to Another Sheet in Microsoft 365

How-to basics · Updated November 21, 2026

To link a cell to another worksheet in the same Excel workbook, enter an equals sign, select the source sheet and cell, then press Enter. For example, if the value is in B2 on a sheet named Sales, the reference is =Sales!B2; the linked cell updates when the source value changes.

What linking sheets means

A worksheet link is a formula reference: one cell displays a value from a different cell, or calculates using values on another sheet. This is useful when a workbook separates raw data, monthly figures, assumptions, and summary reports. Instead of retyping a number on a dashboard, you can link the dashboard to its source so it reflects later edits.

People also use “link” to mean a clickable link that takes them to another sheet. That is different. A formula reference brings a value into the current cell; a hyperlink is for navigation. Choose the method based on whether you want to display information or move to its location.

Link one cell by selecting the source

For a direct reference in Excel for Microsoft 365 on Windows, use these steps:

  1. Open the destination sheet and select the cell where the linked value should appear.
  2. Type =, but do not press Enter yet.
  3. Click the source worksheet tab, then click the cell you want to reference. Excel adds the sheet and cell reference to the formula.
  4. Press Enter. Excel returns to the destination sheet and displays the source cell’s current value.

If the source value is in B2 on a worksheet named Sales, the resulting formula is =Sales!B2. The exclamation mark separates the sheet name from the cell address. If B2 contains 1250, the destination cell displays 1250; if B2 changes to 1400, the linked cell updates to 1400 after recalculation.

You can also type the reference directly. With the source value in Sales!B2, enter =Sales!B2 in the destination cell. This is often fastest when you know the sheet and cell names. The formula points to a cell, not to a fixed copy of the value, so deleting or moving the source may affect the reference.

Reference sheet names that contain spaces

Excel uses single quotation marks around a sheet name when it contains spaces or certain punctuation. For example, if the source is B2 on a worksheet named Sales Data, the reference is ='Sales Data'!B2. The apostrophes are part of the reference syntax and are required in this case. Excel normally adds them automatically when you create the reference by clicking the sheet and cell.

Sheet names without spaces usually do not need quotation marks. For example, if the source value is in C5 on a sheet named Inventory, use =Inventory!C5. You can rename a sheet by double-clicking its tab, but Excel generally adjusts references it recognizes when a sheet is renamed. If you manually build formulas or use text that merely resembles a cell address, check the formulas after renaming.

Link ranges, totals, and copied formulas

A link does not have to display only one value. You can refer to a source range in a formula, or create a row of linked cells and fill the formula across or down. For example, suppose a report sheet should show the product name and sales figure from the same row on the Sales sheet. With product names in Sales!A2:A20 and sales amounts in Sales!B2:B20, enter =Sales!A2 in the report cell for the first product and =Sales!B2 in the adjacent cell for its sales amount. Select both cells and drag the fill handle down to extend the pattern. Excel adjusts row references as the formulas are copied.

To calculate a total from another sheet, use a range reference. With monthly sales amounts in Sales!B2:B20, enter =SUM(Sales!B2:B20) in the destination cell. If the values are 100, 250, and 150, with the remaining cells blank or zero, the result is 500. SUM includes the numeric entries in the specified range; it does not copy that range into the destination sheet.

References are relative by default: when you copy a formula, Excel may change its row or column address to match the new position. To keep a source cell fixed while copying, use dollar signs. If a tax rate is stored in Settings!B2 and an amount is in A2 on the current sheet, the formula =A2*Settings!$B$2 keeps the tax-rate reference fixed when filled down while allowing A2 to become A3, A4, and so on. In Excel, select a reference within the formula and press F4 to cycle through reference styles on Windows; on Mac, the shortcut is typically Command+T, though keyboard settings can affect it.

Link to a cell in another workbook

A cross-workbook link refers to a cell in a separate Excel file. The simplest way to create one is to open both workbooks, copy the source cell, select the destination cell, then choose Home > Paste > Paste Link. Excel creates an external reference rather than a plain pasted value. The exact appearance of the formula depends on the file location, workbook name, sheet name, and whether the source workbook is open.

External links need more care than links between sheets in one file. If the source workbook is moved, renamed, or unavailable, Excel may not be able to find it. When a workbook with external links opens, Excel may show a security prompt asking whether to update linked values. Update only when you trust the source and want the current data; otherwise, keep the existing values. A workbook may also store the last values it successfully retrieved, so a displayed number does not always prove that the source is currently reachable.

For a report that must travel with its data, keeping the linked sheets in one workbook is usually simpler. If you do use external links, store the files in a stable shared location, avoid renaming them casually, and document which file supplies the data. Excel for the web can open workbooks with links, but the available link management and update behavior can differ from desktop Excel, especially for files stored outside supported cloud locations.

Make a clickable link to another sheet

If your goal is to jump to a worksheet rather than show its value, create a hyperlink. Select a cell or text, press Ctrl+K on Windows, choose Place in This Document, select the destination sheet, and specify a cell reference if needed. Choose OK to add the link. In many Microsoft 365 Windows builds, you can also use Insert > Link to open the link options. The link text can say something helpful, such as Open sales details.

A hyperlink does not keep a displayed value synchronized with the destination cell. It only provides a route to the selected location. Conversely, a formula such as =Sales!B2 displays the value but does not make the cell a navigation control. You can use both approaches in the same workbook: a summary can show linked totals and include a separate navigation link to the detailed sheet.

On Mac, use Insert > Link or Command+K to insert a link; names and layout can vary slightly by Excel version. Excel for the web also provides link insertion, but its dialogs and keyboard shortcuts may differ from the Windows desktop steps. The underlying distinction remains the same: a cell reference returns data, while a hyperlink navigates.

Common errors and how to fix them

  • #REF! usually means a formula refers to a cell or sheet that no longer exists, or a referenced range was deleted. Restore the missing sheet or edit the formula to point to a valid location.
  • #NAME? can appear when a sheet name is typed incorrectly or a required name is not recognized. Compare the spelling with the worksheet tab; if the name has spaces, include apostrophes around it.
  • The formula appears as text. The cell may be formatted as Text, or the formula may begin with an apostrophe. Change the cell format to General, then edit the formula and press Enter again.
  • The value looks out of date. Check that the source cell changed and that calculation is not set to Manual. On Windows, use Formulas > Calculation Options > Automatic if automatic calculation is appropriate for the workbook. External links may also need to be updated separately.
  • The wrong result appears after copying. Check whether a relative reference shifted. Add dollar signs to the row, column, or both parts of a reference that must stay fixed.

Also check whether the source cell contains a formula returning an empty string or a value formatted in a surprising way. A direct reference passes along the source’s calculated value, but the destination cell’s number format controls how that value is displayed. If the source shows a date and the destination shows a serial number, apply an appropriate date format to the destination rather than changing the link.

Excel for Windows, Mac, and the web

The basic same-workbook formula syntax is consistent across Excel for Microsoft 365 on Windows, Mac, and the web. You can type a reference such as =Sales!B2 in each version, and clicking the source sheet while editing a formula is also a convenient way to build it. The main differences readers notice are ribbon placement, keyboard shortcuts, and the options available for managing external links.

The steps above use the Windows ribbon names where a menu path is given. On Mac, the ribbon is similar, but shortcut keys differ: Ctrl+K on Windows is generally Command+K on Mac for inserting a link. In Excel for the web, many common formula and link tasks are available in a browser, but advanced workbook features and external-link controls may require opening the file in the desktop app. If a command is missing, check the current version and platform rather than assuming the formula itself is unsupported.

Frequently Asked Questions

How do I link one Excel sheet to another automatically?
Enter a reference such as =Sales!B2 in the destination cell, using the actual source sheet name and cell. The destination displays the source’s current value and updates when that value changes, subject to workbook calculation settings.

How do I link a sheet name with spaces?
Put the sheet name in single quotation marks, followed by an exclamation mark and the cell address. For example, if the source is B2 on Sales Data, use ='Sales Data'!B2.

Can I link an entire worksheet to another sheet?
There is no single ordinary cell formula that turns a whole worksheet into a live duplicate. You can link selected cells or ranges with formulas, use a suitable data-import or Power Query workflow for larger structured datasets, or copy the sheet when you need a separate snapshot. The best method depends on whether the destination must stay synchronized and how much data it contains.

Why does my linked cell show zero or an old value?
Confirm that the formula points to the intended source cell, then check the source value and calculation mode. If the reference is to another workbook, verify that the source file is available and that you have chosen to update its links when appropriate.

How do I make a cell jump to another sheet?
Insert a hyperlink and choose the destination sheet and cell. Use a hyperlink for navigation; use a formula reference when the cell should display the destination’s value.

Can I link between two different Excel files?
Yes. Open both workbooks, copy the source cell, and use Home > Paste > Paste Link in the destination workbook. Keep the source file in a stable location and review Excel’s update prompt when the destination workbook opens.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.