How to Hyperlink to Another Cell in Excel

To hyperlink to another cell in the same Excel workbook, select the cell where the link should appear, press Ctrl+K on Windows, choose Place in This Document, select the destination sheet, enter its cell reference, and click OK. The selected cell becomes a clickable shortcut to the destination. Before you begin, know the destination sheet name and cell address, such as Summary!B4.

What You’ll Need

An Excel workbook saved in a format that supports hyperlinks, such as .xlsx.
The name of the worksheet and the address of the cell you want to reach.
A cell for the link itself, plus any display text you want readers to see, such as “Go to Summary.”

You do not need a formula or an internet connection to create an internal workbook link. The link points to a location in the workbook, rather than to a website or a separate file. If you are sharing the workbook, make sure the destination sheet is included and that recipients have access to the file.

Step-by-Step

Identify the destination. Open the worksheet containing the cell you want people to reach. Note the sheet tab name and the cell address shown at the left of the formula bar when you select the cell. For example, if the destination is cell B4 on a sheet named Summary, the information you need is the sheet name “Summary” and the reference “B4.” Sheet names are not case-sensitive, but spelling and spaces matter. If the destination is on the current sheet, you still need its cell reference.
Choose where the hyperlink will go. Return to the worksheet where you want the link to appear, then select the cell that should hold it. A link can sit beside instructions, in a table of contents, or in a navigation column. Selecting a cell with existing content is allowed, but adding a hyperlink can replace its contents with the link’s display text. Copy anything you need to keep before proceeding.
Open the link dialog. On Windows, press Ctrl+K. You can also use the ribbon: choose Insert > Link. Depending on your Excel build, the command may be labeled Link or Hyperlink. In the dialog’s left pane, choose Place in This Document. Do not choose an existing file or web page for a destination inside the current workbook.
Set the text readers will click. In Text to display, enter a short, informative label such as “Open Summary” or “View March results.” If the selected cell already contains text, Excel may fill this field automatically. You can keep that text or replace it; the display label does not have to match the destination sheet or cell. Avoid labels such as “click here” when a more descriptive phrase would explain where the link goes.
Select the destination sheet. In the section for choosing a place in the document, select the worksheet that contains the target cell. Then enter the destination in the cell-reference box, using a reference such as B4. If you want to link to a named range instead, select that name from the available list when it appears. Check that you have selected the intended sheet, especially if the workbook has similarly named tabs.
Confirm and create the link. Review the display text, sheet, and reference, then click OK. Excel closes the dialog and places the hyperlink in the selected cell. The text commonly appears underlined and in a hyperlink color, although workbook formatting or theme settings can change its appearance. If the dialog includes a ScreenTip button, you may add a short description that appears when someone points to the link; this is optional.
Test the destination. Follow the link and confirm that Excel opens the intended worksheet and moves to the correct cell. In many desktop setups, clicking the link follows it. If a normal click only selects the cell, use the link’s right-click menu and choose Open Hyperlink, or follow the prompt shown by your Excel setup. Check the target again after changing sheet names, moving data, or copying the link to another location.

Mac and web notes: In Excel for Mac, use Command+K or choose Insert > Link; the dialog wording and layout can differ, so look for the option to link to a place in the current workbook. In Excel for the web, use Insert > Link and choose the workbook or sheet destination offered in the dialog. Some controls vary by release. If you do not see an option for a cell reference, open the workbook in the desktop app and create the link there.

Common Mistakes

Choosing the wrong sheet. A reference such as B4 is only meaningful when paired with the correct worksheet. Before confirming, check the sheet selection as well as the cell address. If two tabs have similar names, consider using a clearer name for the target sheet.
Typing a range when you mean one cell. For a single destination, enter one cell reference, such as B4, rather than a range like B4:B10. A range may not take the reader to the specific starting point you intended. To link to the start of a section, use its first relevant cell.
Overwriting useful cell content. The hyperlink label becomes the visible contents of the selected cell. If that cell contains a title or value you need to retain, put the link in another cell or copy the original content elsewhere first.
Using an external-link option by mistake. The dialog may offer choices for a website or another file. Those are different from an internal link and can lead readers outside the workbook. For a cell in this file, choose Place in This Document or the equivalent current-workbook option.
Assuming the link is broken because its color changed. Visited hyperlinks may use a different color, and formatting can override the default appearance. Test the link itself rather than relying on its color to judge whether it works.
Removing the target sheet or changing the workbook structure without checking links. Deleting or renaming sheets, reorganizing content, or copying worksheets can make an existing destination confusing or invalid. Re-test important navigation links after these changes.

Tips

Make the label tell readers what happens. “Go to assumptions” or “Open the quarterly summary” is more useful than “Link” because readers can understand the destination before clicking.
Build a simple navigation area. A contents sheet with one link per major worksheet is helpful in workbooks with many tabs. Keep labels consistent, and place the navigation area somewhere easy to find.
Keep destinations stable. Link to a clear section heading or a cell at the start of a section rather than an arbitrary cell that may become irrelevant when rows are added. Give destination sheets descriptive names, too.
Add a ScreenTip when context would help. A short note can clarify that a link opens a particular report or section. Keep the visible label useful even if someone cannot see the ScreenTip, such as when viewing or printing the sheet.
Use the right kind of link. An internal hyperlink is convenient for navigation, while a formula or a named range may suit more advanced workbook designs. For a straightforward clickable jump to a cell, the Link dialog is usually the simplest approach and avoids having to type a reference string.
Check the link in the shared version. If recipients use Excel for the web, Mac, or an older desktop release, open a copy in that environment when possible. The dialog and click behavior can vary even when the destination is in the same workbook.

Troubleshooting

The link opens the wrong place: Right-click the hyperlink and choose Edit Hyperlink if that option is available. Check both the selected worksheet and the cell reference. For example, if the link should open D12 on a sheet called Budget, confirm that the destination sheet is Budget and the reference is D12. Re-enter the values and click OK, then test again.

The destination sheet is missing from the list: Confirm that the sheet is in the same workbook and is not hidden in a way that prevents it from appearing in the destination picker. If it is hidden, unhide it temporarily, create or edit the hyperlink, and decide whether to hide it again. A hidden destination can be difficult for recipients to find, so consider whether the sheet should remain visible.

Excel selects the link instead of following it: Use the context menu’s Open Hyperlink command or follow any on-screen prompt. If the workbook is in cell-editing mode, press Enter or Esc to leave editing and try again. A link may also behave differently in a browser or remote desktop session than in the Windows desktop app.

The link text is not visible as expected: Select the cell and inspect its contents in the formula bar. If the label is there but hard to see, adjust the font color or cell formatting; workbook styles can make a hyperlink look unlike the default. If the cell is blank or shows the wrong label, edit the hyperlink and correct Text to display.

The hyperlink command is unavailable or the link cannot be edited: Check whether the worksheet or workbook is protected. Protection can restrict editing, and a workbook opened read-only will not let you save changes to the original. If appropriate, ask the owner for edit access or work on an authorized copy, then create or update the link there.

A link stops working after a change: Reopen the link settings and select the destination again. If a sheet was renamed, moved, or removed, update the link to match the workbook’s current structure. Re-test links after making structural changes, especially in a navigation sheet that many people rely on.

Frequently Asked Questions

Can I link to a cell on the same worksheet?

Yes. Select Place in This Document, keep the current worksheet selected, and enter the target cell reference. The link can jump up or down the same sheet just as it can move to another sheet.

Can I link to a cell on a different worksheet in the same workbook?

Yes. Choose the destination worksheet in the link dialog, enter the target cell address, and confirm. The workbook remains open; selecting the link navigates to that location.

Can I change what the hyperlink says?

Yes. Right-click the link and choose Edit Hyperlink, then change the Text to display field. You can also replace the cell’s contents with new text, but editing the hyperlink is the clearer way to preserve and review its destination.

Can I make a shape or picture link to another cell?

Yes. Select the shape or picture, press Ctrl+K on Windows, and choose the current-document destination. On Mac, use Command+K. The exact controls can vary by Excel version, so confirm that the link dialog lets you choose a location in the workbook.

Does the hyperlink update automatically if I move the target cell?

Do not assume that a link will still point to the intended content after reorganizing a sheet. Excel may preserve a reference in some edits, but inserting, deleting, copying, or moving cells can affect how useful the destination is. Test the link after structural changes and edit it if necessary.

Will an internal hyperlink work if I email the workbook?

It should navigate within the workbook when the recipient can open the file and the destination sheet and cell are still present. The recipient does not need access to a website for an internal link, but workbook protection or a different app may affect editing or click behavior.

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.