To add a hyperlink in Excel for the web, select a cell, choose Insert > Link (or press Ctrl+K on Windows), enter the destination and display text, then insert the link. You can link to a website or, where the link dialog offers the option, to a sheet or location in the current workbook. Before sharing the file, test the link and check that the people using it can access its destination.
What You’ll Need
- An Excel workbook open in Excel for the web, with permission to edit it.
- The website address, email address, or workbook location you want the link to open. For an online file, use a link its intended readers can access.
- Optional: short, descriptive text to show in the cell instead of a long web address.
Step-by-Step
- Open the workbook and choose a cell. Go to the worksheet where the link belongs and select the cell that should contain it. If the worksheet already has a label such as “Project brief,” select that cell to make the label clickable. Otherwise, select an empty cell. A hyperlink is attached to the cell, so choose a place that makes sense alongside the related data.
- Open the link tool. On the ribbon, select Insert > Link. You can also try Ctrl+K on Windows or Command+K on a Mac. Keyboard shortcuts can vary with browser settings; if the shortcut opens a browser feature or does nothing, use the ribbon command instead. If Link is unavailable, check that the workbook is not open in read-only mode and that you have edit access.
- Choose what the cell should display. In the link dialog, look for a field such as Text to display. Enter concise wording that tells readers what they will open, for example “Read the installation guide” or “Open the April report.” If you selected a cell that already contains useful text, keep it as the display text rather than replacing it with a lengthy address. Dialog labels and layout can differ as Excel for the web is updated.
- Enter or select the destination. For a website, enter its full address, including the protocol when available, such as
https://example.com/guide. For a shared document, paste the online sharing link rather than a local computer path such asC:\Reports\April.xlsx; other people cannot use a path that exists only on your device. If the dialog provides a way to browse or choose a recent online file, confirm that you select the intended file. - Link to a place in the current workbook, if needed. For a navigation link to another sheet or cell, look for an option such as Place in this document, or a list of sheets or workbook locations in the link dialog. Select the intended sheet or location and confirm it. The wording and availability of this choice can vary in Excel for the web. If you do not see an internal-location option, do not paste a guessed address; use the navigation features available in your version or create a normal web link instead.
- Insert the link. Review the displayed text and destination, then select Insert or the confirmation button shown in the dialog. Excel for the web saves changes to an online workbook automatically, but allow a moment for the change to appear. If you are working in a shared file, make sure the selected cell is in the correct worksheet and that you have not overwritten a neighboring value.
- Test the link. Select the linked cell and use the link pop-up or its Open link action if Excel displays one. A web destination may open in a new browser tab; an internal link should take you to the chosen workbook location. Verify that the destination is correct and that it loads for the account you expect readers to use. Close the new tab when you are done, then return to the workbook.
- Edit or remove a link when necessary. To change it, select the cell and use the link pop-up, ribbon command, or right-click menu to find Edit link or a similar option. Replace the destination or display text, then confirm. To remove the link but keep the cell’s wording, use Remove link if it appears in the menu. Deleting the cell’s text is not necessary just to make it plain text.
Common Mistakes
Using a local file path. A path that begins with a drive letter or points to a folder on your computer will not reliably work for workbook readers online. Upload the file to OneDrive, SharePoint, or another service your readers can access, then use its shareable link. Check the sharing permissions as well as the address: a correct URL can still lead to an access-denied page.
Leaving an unclear or overly long label. A full URL in a cell can be difficult to scan, especially in a report or dashboard. Use a meaningful phrase instead, but avoid labels such as “click here” when several links appear together. “Open the safety checklist” tells readers more than “Click here.” Keep enough context around the link that its purpose is clear.
Linking the wrong cell or destination. It is easy to select a neighboring cell or paste a link to an older version of a file. Check the selected cell before inserting, and open the link afterward to confirm its destination. When a workbook contains several similarly named sheets or reports, verify the specific one rather than relying on the display label alone.
Assuming everyone has permission. Excel can create a link to a private file, but it cannot grant every reader access automatically. A colleague may see a sign-in prompt or a permission request. Set the file’s sharing access appropriately and follow your organization’s rules for sharing sensitive information.
Tips
Use a consistent style for links in a workbook, such as a short action phrase or a file name followed by its purpose. This makes link cells easier to recognize without requiring every label to repeat the destination. If readers might print the worksheet, consider whether the printed page should also show the web address or another way to find the resource; the clickable behavior itself will not transfer to paper.
For a list of related resources, keep the destination in one column and the clickable label in another. That makes it easier to review or update addresses later. For example, with a full URL in cell A2 and a link label wanted in cell B2, enter =HYPERLINK(A2,"Open the project brief") in B2. The result in B2 is the clickable text “Open the project brief,” which points to the address in A2. Make sure A2 contains a valid destination. Excel for the web supports the HYPERLINK function; if you prefer a menu-created link, use the Insert command instead.
When a cell contains a formula-generated link, changing the URL in the referenced cell can update the destination without rebuilding each link. Keep the source URL column visible to workbook editors or document its purpose so an address is not accidentally replaced. For a small number of links, the link dialog is often simpler; a formula is useful when you are creating a repeatable set of labels and destinations.
Keep the destination stable when possible. A link to a general information page is less likely to break than a link to a temporary download or a file that will soon be moved. For shared files, test with the same kind of account your audience will use. If a workbook is shared externally, confirm that the intended recipients can reach both the workbook and the linked resource.
Troubleshooting
The Link command is missing or disabled: confirm that you opened the workbook in Excel for the web and have editing permission. If you are viewing a read-only copy, ask for edit access or open an editable version. Also check whether a dialog or cell edit is currently active; finish or cancel it, then select the cell again and reopen the Insert tab.
The link opens the wrong page or reports that the address cannot be found: edit the link and inspect the entire destination, including spelling, punctuation, and any extra spaces. Paste the address into a new browser tab to see whether it works independently. If it does not, obtain a current link from the site or file owner. Do not assume a displayed label proves the underlying destination is correct.
The destination opens but asks for access: this is usually a sharing-permission issue rather than a problem with the Excel hyperlink. Ask the file owner to grant the intended account access, or create a sharing link with suitable permissions under your organization’s policy. Avoid changing a private file to public access merely to make a link work.
The link does not open when you select the cell: look for a link preview or an Open link option, since selecting a cell can first show its details rather than immediately navigating. If the browser blocks a new tab, allow pop-ups for the Excel site or use the link’s open action again. You can also right-click the linked cell and check for an open-link command.
The link text looks like a URL instead of your label: edit the link and check the Text to display field. If you used the HYPERLINK formula, check that the friendly text is included as the second argument and that the formula was entered in the intended cell. If the cell shows formula text instead of a result, confirm that the entry begins with = and that the cell is not being treated as plain text.
Frequently Asked Questions
Can I hyperlink text in Excel for the web?
Yes. Select the cell containing the text, open Insert > Link, and enter the destination. The cell’s text can remain as the clickable label. Excel links cells, so text within a cell is not independently linked in the same way as separate words in a word-processing document.
Can I link to another worksheet in the same workbook?
Often, yes. Use the internal-location or sheet option in the link dialog if your version presents it, then choose the target. Check the link after inserting it. If that option is not available in your Excel for the web interface, the exact method may differ by version; do not treat a normal website address as an internal sheet link.
Can I add a hyperlink to an email address?
You can use an email link if the link dialog accepts an address such as mailto:help@example.com. When a reader opens it, their device or browser may ask which email app to use. The link does not send a message by itself, and the recipient still needs to review and send the email.
Will a hyperlink work for everyone who receives the workbook?
Not necessarily. The destination must still exist, and the reader must have permission to open it. Links to public websites are usually accessible to anyone with an internet connection, while OneDrive or SharePoint files may require a particular account or sharing permission.
How do I remove a hyperlink without deleting the cell contents?
Select the cell, open its link options or right-click menu, and choose Remove link if available. This removes the clickable destination while retaining the label. If the menu wording differs, use the link-editing controls in the version of Excel for the web you are using.
Can I make a hyperlink with a formula?
Yes. The HYPERLINK function can return clickable text from a destination, as in the example in Tips. Use the Insert link dialog if you would rather create or edit one link without writing a formula.
Related
- How to Autofill in an Excel Table: Steps That Work
- Power Query Data Validation in Excel: What It Can Do
- Excel Data Validation: Create Rules and Drop-Down Lists
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Sum a Column in Google Sheets: Formulas and TipsTo sum a column in Google Sheets, enter =SUM(B2:B10) in an empty cell, replacing the range with the…
- How to Count in Excel: COUNT, COUNTA, and MoreTo count numeric values in a range, enter =COUNT(A2:A10) in an empty cell, assuming the values you want…
- How to Freeze Selected Rows in Excel Without Freezing AllTo freeze selected rows in Excel, select the cell in column A immediately below the last row you…
- Excel Sum Minus: How to Add and Subtract Numbers in ExcelTo subtract a value from a total in Excel, combine SUM with the minus sign: with numbers in…
- How to Add a Shared Mailbox Folder in Outlook 365To add a shared mailbox folder in Outlook, first get permission to the mailbox or folder, then add…
- How to Sort a Table by Date in Google Sheets Without ErrorsTo sort a table by date in Google Sheets, select the whole table, choose Data > Sort range…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.