Yes. In Excel, you can link cells with a formula that displays another cell’s value, whether the source is on the same sheet, another sheet, or—in many cases—another workbook. If by “link” you mean a clickable jump, you can instead add a hyperlink; these methods do different things.
What linking cells in Excel means
A cell link is a connection between a destination cell and a source. With a formula link, the destination shows the source cell’s current value, and Excel recalculates the formula when the source changes. The destination does not become a second editable copy of the source: you normally change the source cell, not the formula cell.
People also use “link” to mean a clickable hyperlink, a connection to data in another file, or even joining cells together. Those are distinct operations. A formula reference brings a value into a cell; a hyperlink opens a location when clicked; and merging cells combines a group of cells into one larger display area. Choosing the right meaning first helps avoid a link that looks right but does not behave as expected.
Link cells on the same worksheet
To show one cell’s value in another cell on the same worksheet, select the destination, type an equals sign, select the source cell, and press Enter. You can also type the reference directly. With a source value of 42 in A1, and the formula entered in B1, use =A1. B1 displays 42 and updates if A1 changes.
This is useful for repeating a total near a chart, displaying a key figure at the top of a long sheet, or using one input in several calculations. If the source contains text, the destination displays that text; if it contains a date, the linked cell displays the date’s underlying value using its own number format. The formula transfers the cell’s result, not its appearance.
You can link a range of cells at once by copying the source range and using Paste Special > Paste Link. Excel fills the corresponding destination cells with references. Review the resulting formulas, especially if the destination starts in a different location, because relative references may shift.
Reference a cell on another worksheet
A formula can point to a different worksheet in the same workbook. The basic pattern is a sheet name, an exclamation mark, and the cell address. With a value of 125 in B4 on a worksheet named Sales, enter =Sales!B4 in the destination cell on another sheet. The result is 125, and it follows changes to Sales!B4.
If a sheet name contains a space or certain punctuation, Excel puts single quotation marks around the name. For example, a reference to B4 on a sheet named Quarter 1 is written ='Quarter 1'!B4. A reliable way to create either kind of reference is to type = in the destination cell, click the source sheet tab, select the source cell, and press Enter. Excel writes the reference syntax for you.
References can cover ranges too. With monthly values in B2:B13 on a worksheet named Sales, the formula =SUM(Sales!B2:B13) adds them together. If those values are 10, 20, and 30, with the remaining cells empty or zero, the result is 60. This is a formula using a range from another sheet, rather than a link to just one cell.
Use relative and absolute references deliberately
When you copy a formula, Excel usually adjusts its cell references relative to the new location. For example, copying =A1 one column to the right normally changes the reference to B1. This behavior is helpful when filling a row or column of formulas, but it can be surprising if every copied formula is meant to point to one fixed input.
To keep a reference fixed when copying, add dollar signs. With a tax rate stored in B1 and amounts in A2:A4, enter =A2*$B$1 in the calculation cell on row 2, then copy it down. The row reference to A2 adjusts for each row, while $B$1 remains fixed. In Windows, select a reference while editing a formula and press F4 to cycle through relative and absolute reference styles. On Mac, the equivalent shortcut is commonly Command+T; keyboard mappings can vary by configuration, so inserting the dollar signs manually also works.
Link to a cell in another workbook
An external workbook link points to a cell in a separate Excel file. One way to create one is to open both workbooks, start a formula in the destination workbook, switch to the source workbook, select the cell, and press Enter. Excel creates an external reference. A simplified example is ='[Sales.xlsx]Summary'!B2, which refers to B2 on the Summary sheet in Sales.xlsx. When the source workbook is closed, Excel may include its folder path in the reference.
External links are useful for a report that draws selected figures from a separate source file, but they add a dependency: the source file needs to remain available at the expected location. Moving or renaming it can cause a broken link or a request to locate the file. If Excel asks whether to update links when a workbook opens, consider whether you trust the source and whether you need its latest values. A link to another workbook is not the same as importing and permanently copying all of its data.
In current Microsoft 365 for Windows, the Data tab may provide Workbook Links for viewing and managing external workbook connections. Some earlier Excel versions show an Edit Links command instead, and available controls can differ by version. If you distribute a workbook, tell recipients where its source files are or consider a self-contained copy when live updates are not needed.
Create a clickable hyperlink instead
A hyperlink makes a cell clickable; it does not make the cell display a live value from another cell. To add one in Excel for Microsoft 365 on Windows, select a cell and press Ctrl+K, or use Insert > Link. Enter a web address, file path, or place in the workbook, then confirm. On Mac, Command+K opens the link dialog in many current Office configurations; the Insert tab also has a Link command.
You can also use Excel’s HYPERLINK function. With a web address in A2 and the display text Open source in B2, enter =HYPERLINK(A2,B2) in C2. C2 displays Open source as a clickable link to the address in A2. This is convenient when the destination and label are stored in cells, but the result is still a navigation link, not a formula that mirrors the contents of another cell.
Choose the method that matches your goal
Use a formula reference when the destination should show a source value, and use a hyperlink when a person should be able to open a location. For repeated calculations, a formula such as SUM over a source range can be more useful than linking each number separately. If you need a refreshed table of imported records, an external workbook formula may not be the best fit; an import or query workflow can be easier to maintain.
- Display one cell’s current result: enter a direct cell reference such as
=A1. - Bring in a value from another sheet: use a sheet reference such as
=Sales!B4. - Use values from another file: create an external workbook reference and keep the source file accessible.
- Let someone click to a website, file, or worksheet location: insert a hyperlink.
- Combine or summarize source values: use a suitable formula or consider an import tool rather than creating many fragile individual links.
For a one-time snapshot, copying and pasting values may be more appropriate than maintaining a live link. In Excel, Paste Special offers a Values option; this places the current results in the destination without formulas that keep following the source. The trade-off is that later edits to the source will not update the pasted values.
Updates, formatting, and common problems
Formula links recalculate according to the workbook’s calculation settings. If a linked value seems stale, check whether calculation is set to Automatic on the Formulas tab under Calculation Options. With external workbook links, also check whether the source file can be found and whether you chose to update its values. Excel may display a cached result when an external source is unavailable, so a displayed number is not proof that the link has refreshed.
A linked cell inherits neither the source cell’s formatting nor its full behavior. For example, a formula returning a date can appear as a number if the destination uses General format; apply a date number format to the destination if that is what you want to see. Formatting, comments, data validation, and column widths are separate from the formula reference.
Another common surprise is a zero in the destination when the source cell is blank. A direct reference can display 0 for a blank source. If you want the destination to remain visually empty when A1 is blank, with A1 as the source and B1 as the destination, use =IF(A1="","",A1). If A1 is empty, B1 displays an empty string; otherwise it displays A1’s value. This returns an empty text result, which is not identical to a truly unused cell in every calculation.
Finally, two-way linking is not what a normal cell reference does. If A1 refers to B1 and B1 also refers to A1, the formulas create a circular reference. Excel may warn about it, and iterative calculation is a specialized setting rather than a safe way to make two cells behave like synchronized inputs. Usually, designate one cell as the source of truth and have the other cells refer to it.
Frequently Asked Questions
Can I link cells in Excel so changes update automatically?
Yes. A formula reference such as =A1 updates when A1 changes, provided Excel recalculates the workbook. A link to a different workbook also depends on that source file being available and its values being updated.
Can I link cells between two Excel workbooks?
Yes. Create an external reference by starting a formula in one workbook and selecting a cell in the other. Keep the source workbook in a stable location, and check update prompts when opening the destination file.
How do I link to a cell on another sheet?
Use the sheet name, an exclamation mark, and the cell address, such as =Sales!B4. If the sheet name contains spaces, Excel encloses it in single quotation marks.
Can I make a cell clickable without showing another cell’s value?
Yes. Insert a hyperlink with Ctrl+K on Windows, or use the Insert tab’s Link command. A hyperlink navigates to a destination; it does not mirror a source cell’s changing value.
Can one cell update another in both directions?
Not with ordinary cell references. A formula link flows from its source to its destination. Use one input cell as the source of truth rather than creating circular references between two cells.
Related
- Bluebeam Export to Excel: Steps, Fields, and Fixes
- Blank Checklist Template Excel: Create One That Works
- Bloomberg Excel Add-In Repair and Troubleshooting
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Excel Formula If Cell Contains Value: Practical ExamplesTo return one result when a cell is not empty and another when it is empty, use =IF(A2<>"","Yes","No").…
- IFERROR Function in Excel: Syntax, Examples, and TipsIn Excel, use IFERROR to return a chosen result when a formula produces an error: the syntax is…
- Excel COUNTIF Range Examples: Text, Numbers, and DatesUse Excel’s COUNTIF function to count cells in a range that match one condition: for example, =COUNTIF(A2:A20,"East") counts…
- Sort Excel by Number: Steps, Options, and Common FixesTo sort numbers in Excel, select a cell in the number column, then choose Data > Sort Smallest…
- Excel Filter to Show Duplicates: A Practical GuideTo show duplicate values in Excel, select the column, choose Home > Conditional Formatting > Highlight Cells Rules…
- Calendar Day Formula in Excel: Dates, Weekends & MoreFor the day number within a date, use =DAY(A2), where A2 contains an Excel date; for example, January…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.