In Excel for the web, select a cell, choose Insert > Link, and select the destination sheet or named range to make a clickable link to another sheet. If you want to show a value from that sheet rather than navigate to it, enter a cell reference such as =Sheet2!A1 instead.
Two different ways to connect worksheets
The phrase “link to another sheet” can mean two different things. A hyperlink is a clickable signpost: selecting it takes you to a place in the workbook. A worksheet reference is a formula: it displays or calculates with information stored on another sheet. Picking the right one matters because they solve different problems.
For example, a contents page might have a link labelled “Open sales data” that jumps to the Sales Data worksheet. A summary page might instead display the current total from a cell on Sales Data. The first is a navigation link; the second is a formula connection. You can use both in the same workbook.
- Use a hyperlink when readers need to jump to a worksheet or a particular cell.
- Use a cell reference when a value on one sheet should appear on another and update when the source value changes.
Create a clickable link in Excel for the web
Open the workbook in Excel for the web, then choose a cell that will contain the link. The cell can be blank, or it can already contain text you want to turn into a link. To add a link through the ribbon:
- Select the cell where the link should appear. If the cell already has text, select that cell rather than editing the text first.
- Choose Insert > Link.
- In the link pane or dialog, enter the text readers should see, if needed. Choose the option for Sheets and named ranges, then select the destination sheet. If the interface offers a cell-reference field, enter a destination such as
A1to jump to a specific cell; otherwise, the link can go to the sheet. - Confirm the link. Select the linked cell to follow it. Depending on the current Excel for the web interface, you may need to select the link preview or choose its open-link action rather than simply clicking once.
The exact wording and layout of the link dialog can change as Microsoft updates Excel for the web. If you see a choice to link to a sheet or named range, use that for an in-workbook destination. Do not paste a web address for a sheet in the same workbook: a worksheet destination is not a separate public URL.
In many Excel environments, Ctrl+K opens the link command on Windows, and Command+K is the corresponding Mac shortcut. Browser shortcuts and keyboard settings can affect shortcuts in Excel for the web, so use Insert > Link if the shortcut opens a browser feature instead.
Link to a specific cell or create a contents page
A link to a sheet is useful when the destination worksheet is short. For a large worksheet, a link to a particular cell can save readers from having to search for the relevant section. For instance, a workbook contents page could point to the first row of each department’s report, while a “Back to contents” link on each report returns readers to the index.
When the link dialog lets you choose a cell reference, use the destination address without confusing it with the link’s display text. The display text is what appears in the source cell, such as “Open March report”; the destination is where Excel moves the selection. A descriptive label is usually more helpful than showing a bare address such as “Sheet4!A1.”
For a workbook with many sheets, consider giving important destination cells a name. A named range such as MarchSummary can be easier to recognize in a list than a cell address, and it remains meaningful if readers do not know the worksheet layout. Named ranges must exist in the workbook before a link can use them. If you are sharing the workbook with others, keep link labels consistent and make sure the destination is not hidden or protected in a way that prevents readers from using it.
Use a formula to display a value from another sheet
A cross-sheet formula retrieves a value; it does not create a navigation control. To refer to cell A1 on a sheet named Sheet2, enter the reference in the destination cell. With the destination formula entered in any cell on another worksheet, the formula is =Sheet2!A1. It displays the current value of Sheet2 cell A1 and recalculates when that source value changes.
If the sheet name contains spaces or punctuation, surround the name with single quotation marks. For example, with a sheet named Sales Data and the value to retrieve in A1, use ='Sales Data'!A1. The leading equals sign makes this a formula, the exclamation mark separates the sheet name from the cell address, and the quotation marks make the multiword sheet name unambiguous. The result is the value currently stored in Sales Data!A1.
You can also refer to a range for calculations. With monthly figures in B2:B13 on the Sales Data sheet, enter this in the summary cell: =SUM('Sales Data'!B2:B13). The formula adds those 12 cells. If the source cells contain 10, 20, and 30 with the remaining cells blank, the result is 60. A reference updates the result as its source values change; it does not copy the source formatting or create a clickable link.
Create a clickable link with HYPERLINK
For a link whose label or destination is generated by a formula, Excel also provides the HYPERLINK function. It is different from a plain sheet reference: it makes a clickable link rather than displaying the source cell’s value. With the destination in cell A1 of a worksheet named Sales Data, enter this formula in the cell where the link should appear: =HYPERLINK("#'Sales Data'!A1","Open sales data"). The displayed text is “Open sales data,” and selecting it takes the reader to A1 on Sales Data.
The hash mark at the start identifies an in-workbook destination, and the single quotes surround the sheet name because it contains a space. If the sheet name has no spaces, the destination can be simpler, such as =HYPERLINK("#Sheet2!A1","Open Sheet2"). For sheet names with spaces, retain the quotation marks around the sheet name inside the destination text. Formula links are useful for repeatable navigation labels, but a manually inserted link is often simpler when you only need one or two links.
Hyperlinks versus references: which should you choose?
Choose based on what you expect the reader to do. If the reader should move to another worksheet, use a hyperlink. If the reader should see a value without leaving the current sheet, use a reference. If a summary should show a value and offer a way to inspect its source, put the reference in one cell and a separate hyperlink nearby.
- Navigation: A hyperlink takes the user to a sheet, cell, or named range. It does not automatically bring the source value into the current cell.
- Live display: A reference such as
='Sales Data'!A1displays the source value and normally updates with it. It does not move the selection to the source. - Calculated summary: A formula such as SUM can calculate over another sheet’s range. It returns a result, not a navigation link.
- Combined experience: A dashboard can show the latest total using a reference and provide a clearly labelled link to the underlying detail.
One common misconception is that typing a sheet reference into a cell automatically makes the cell clickable. It does not. A reference is evaluated as a formula. Likewise, a hyperlink does not keep a displayed number synchronized with a source cell unless the link itself is built as part of a formula or the value is separately referenced.
Common problems and ways to fix them
If the link does not open the expected destination, first check that the destination sheet still exists and that you selected the intended sheet or range in the link dialog. A link can become confusing after someone renames or reorganizes worksheets, especially in a workbook with similarly named tabs. Try the link in the saved workbook and confirm where the active cell lands.
If a formula displays an error or does not return the expected value, check these details:
- Sheet name spelling: The name in the formula must match the worksheet tab. Include single quotes around names with spaces, as in
='Sales Data'!A1. - Cell address: Confirm that the source cell or range is correct and that the worksheet has not been renamed.
- Formula versus text: Make sure the entry starts with an equals sign and is not stored as plain text. A leading apostrophe or a Text cell format can cause Excel to show the formula characters instead of calculating them.
- Link activation: In Excel for the web, selecting a linked cell may show a preview or action menu. Use the available open-link control if a single click only selects the cell.
- Access and sharing: A workbook link does not grant someone permission to view the workbook. A recipient still needs access to the file itself.
Another frequent mix-up is confusing a link to a worksheet in the current workbook with a link to a different workbook stored online. An in-workbook link navigates within the open file. A link to another file is a separate sharing or file URL, and the recipient may need permission to that other file. Do not assume that making a worksheet hyperlink also changes the workbook’s sharing permissions.
Excel for the web and desktop differences
Excel for the web and Excel for Microsoft 365 desktop share the basic ideas: in-workbook hyperlinks navigate, and cross-sheet formulas return values. The interface for creating a link can differ. In the desktop Windows app, the Insert Link dialog may present a clearly named “Place in This Document” option; in the web app, look for the sheet or named-range destination in its link interface. Use the current ribbon and dialog labels rather than relying on a desktop screenshot when working in a browser.
On Mac, the ribbon layout and keyboard shortcut can differ from Windows, though the same workbook concepts apply. In Excel for the web, browser and operating-system shortcuts may also affect shortcut behavior. The most portable instruction for a reader using the web app is to select the destination cell and use Insert > Link. Formula syntax is not different merely because the workbook is open in a browser, though regional settings can affect formula argument separators in some Excel configurations.
Frequently Asked Questions
How do I link to another sheet in Excel Online?
Select the cell for the link, choose Insert > Link, then choose the sheet or named range destination in the link interface. Add a cell address if you need the link to jump to a particular cell, and confirm the link.
How do I show a cell from another sheet?
Enter a cross-sheet formula in the cell where the value should appear. For example, if the source is A1 on Sheet2, use =Sheet2!A1. If the worksheet name contains spaces, use single quotation marks around the sheet name, such as ='Sales Data'!A1.
Can I make a cell jump to a specific cell on another sheet?
Yes. When creating an in-workbook hyperlink, select the destination worksheet and provide the target cell address if the dialog offers that field. A formula using HYPERLINK can also create a link to a specific in-workbook cell.
Does a hyperlink update when the source cell changes?
A hyperlink is for navigation, not for displaying a live source value. Use a cross-sheet reference or calculation if the current value should appear in the destination cell and update when the source changes.
Why does my formula show instead of the result?
Check that the entry begins with an equals sign and that the cell is not treating it as text. If necessary, change the cell format to General, then re-enter the formula. Also check for a leading apostrophe before the equals sign.
Does linking to a sheet let other people open my workbook?
No. A worksheet link only points to a location inside the workbook. People still need permission to open the workbook, and they may need separate access if the destination is actually a different file.
Related
- Data Validation Studio: Excel Rules, Setup, and Limits
- Power Query Circular Reference: Causes and Fixes
- Excel Data Validation Source: Lists, Ranges, and Rules
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Remove Duplicates Shortcut Key: What to PressIn Excel for Microsoft 365 on Windows, press Alt, then A, then M to open Remove Duplicates. These…
- Excel Not Responding and Unsaved? Recover Your WorkIf Excel is not responding and your work is unsaved, wait briefly and avoid repeatedly clicking; the app…
- Excel: Sum Values Based on Other ValuesYes. In Excel, use SUMIF to add values that match one condition, or SUMIFS to add values that…
- How to Freeze a Header Row in Excel While ScrollingTo keep your column headings visible while you scroll in Excel for Microsoft 365 on Windows, select View…
- How to Delete Blank Cells in Excel SafelyTo delete genuinely empty cells in Excel for Microsoft 365 on Windows, select the range, choose Home >…
- Why Can’t I Add a Header in Word?You usually can’t add a header in Word because the document is not currently editable, editing is restricted,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.