To make a word in Excel open a webpage, put that word in a cell, select the cell, press Ctrl+K on Windows, enter the web address in the Address field, and choose OK. The hyperlink is attached to the whole cell, not just a few characters within it. If the word sits inside a longer sentence in one cell, use a separate cell or a text box for a clickable word.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365. The steps below are for Excel on Windows.
- The word or short label you want people to click, such as Read more, Product details, or Help.
- The destination: a complete web address, a cell or sheet in the workbook, or a file location. For a website, copy its full URL, including https:// when available.
- Permission to access the destination. A link to a restricted website, shared file, or network drive will not grant access by itself.
You do not need a formula or add-in for a basic hyperlink. If you are preparing a list of links, it helps to decide whether the displayed words should be descriptive rather than showing a long raw web address.
Step-by-Step
- Enter the clickable word in a cell. Click a blank cell and type the label you want displayed, for example, Open the guide. Press Enter. If the word is already in its own cell, keep it there. Excel treats the cell as the hyperlink object, so you do not need to highlight the word by double-clicking it. If the cell contains a longer sentence and only one word should be clickable, skip to the workaround in step 7.
- Select the cell, then open the link command. Click the cell once so it has the selection border. On Windows, press Ctrl+K. You can also use Insert > Link on the ribbon, or right-click the cell and choose Link. Depending on the Excel update, the dialog may be labeled Insert Hyperlink or Insert Link. These options open the interface for adding a destination while keeping the cell’s displayed text.
- Check the displayed text. In the dialog, look for the Text to display field. It should contain the word or label from the selected cell. If you started with a blank cell, enter the label here. Keep it short but clear enough that someone can tell what will open; for example, use View the return policy rather than Click here. If you change the displayed text in the dialog, Excel uses that as the cell’s visible label.
- Enter a website address. Choose the option for an existing file or web page if the dialog presents destination types, then click the Address field. Paste the full URL, such as https://www.example.com/help, and review it for missing characters or spaces. Use the actual address of the page you intend to open, not just the site’s home page unless that is the goal. Select OK to save the link. The cell should now display the label, usually with hyperlink formatting such as colored, underlined text.
- Test the link. On Windows desktop Excel, a single click may select the cell rather than follow the link. Hold Ctrl and click the linked cell to open its destination. You can also right-click it and choose Open Hyperlink. Check that the correct page opens and that it does not show an error or redirect to an unrelated location. Close the browser tab or window when finished and return to the workbook.
- Link to a place in the same workbook instead, if needed. Select the cell that will display the link and open Insert > Link or press Ctrl+K. In the dialog, choose Place in This Document, select the target sheet, and specify the cell reference if prompted. Confirm the dialog. This is useful for a contents list that jumps to a section on another worksheet. Test it after saving, especially if you renamed or moved the destination sheet.
- Use a workaround when only one word in a cell should be clickable. Excel does not let you attach a standard hyperlink to just a substring of a cell’s text. Put the linked word in a neighboring cell, then adjust the column widths and formatting so the words read naturally. Alternatively, insert a text box from Insert > Text Box, type the label in it, select the text box, and add a hyperlink to the object. A text box link applies to the object rather than to selected characters within a sentence, so it is best for a standalone label. For a compact data table, splitting the sentence across cells is usually easier to maintain.
Mac and web differences: In Excel for Mac, select the cell and press Command+K, or use Insert > Link; dialog wording and layout can vary slightly. To follow a link, use the link’s context menu if a normal click only selects it. Excel for the web also supports inserting links through Insert > Link or Ctrl+K, but the dialog may be more compact and some desktop options can differ. If a command is unavailable in the browser, open the workbook in the desktop app and add or adjust the link there.
Common Mistakes
- Expecting a link on only part of a cell’s text. Selecting a few characters while editing a cell does not create a character-level hyperlink in Excel. The link belongs to the cell. Put the linked label in its own cell, or use a linked text box when a separate object fits the layout.
- Entering an incomplete or incorrect address. A missing character, an old page address, or an accidental space can make a link fail. Copy the URL from the browser’s address bar and paste it carefully. For web destinations, prefer the secure https:// address when the site provides one.
- Replacing the label when you meant to add a link. Typing while the cell is selected replaces its contents. Use Ctrl+K or Insert > Link to open the hyperlink dialog; do not start typing a URL into the selected cell unless you want the URL itself to appear there.
- Assuming a link gives recipients access. A workbook can contain a link to a private file or a permission-controlled website, but recipients still need access rights. Check sharing permissions separately and avoid linking to a file path that exists only on your computer.
- Testing with an ordinary click and deciding the link is broken. Desktop Excel often selects a linked cell on a normal click. Use Ctrl+click on Windows, or the context-menu command Open Hyperlink, to test it.
Tips
- Write link text that describes the destination or action. Labels such as Download the schedule and Open the sales worksheet are easier to understand than a bare URL or here.
- Keep one main destination per cell. If a row needs several links, use separate columns or distinct text-box objects so each target is easy to select, edit, and check.
- For links to workbook sections, use stable sheet names and cell locations, then test the link after reorganizing the workbook. Moving content or renaming sheets can make a destination confusing or outdated.
- Use consistent formatting for linked labels so readers recognize them, but do not rely on color alone. Clear wording remains useful for people who print the sheet or have difficulty distinguishing colors.
- When distributing a workbook, test links from the copy or shared location that recipients will use. A link that works on your computer may point to a local folder or an internal company site that others cannot reach.
- If the link text is too long for a column, widen the column, wrap the text, or choose a shorter but still meaningful label. Avoid hiding the label behind adjacent cell contents, since that can make a useful link hard to spot.
Troubleshooting
The link opens the wrong page: Select the linked cell, open Ctrl+K, and inspect the Address field. Correct the URL and select OK. If the link goes to a search page or a redirect, copy the final page address directly from the browser and replace the old one.
Clicking only selects the cell: This is normal in many desktop Excel setups. Hold Ctrl while clicking on Windows, or right-click and choose Open Hyperlink. If you changed Excel’s hyperlink-click behavior, check File > Options > Advanced under Editing options for the setting about using Ctrl+Click to follow hyperlinks.
The link text or formatting looks wrong: Reopen the link dialog and check Text to display, then confirm. If the displayed text is correct but the color or underline is not, cell formatting may have been changed. Select the cell and apply the desired font formatting from Home; changing appearance does not change the destination.
The link does not work for another person: Ask them to confirm that they are online and can access the destination directly. For shared files, use a share link and set appropriate permissions rather than linking to a local path such as a folder on your own computer. For a workbook-to-workbook link, confirm that the linked file has not been moved or renamed.
You cannot find Place in This Document: Check that you opened the full link dialog rather than a small quick-link menu, and look at the dialog’s left-side destination list. Excel for the web and some interface updates may show a different set of options. Open the workbook in desktop Excel if the required internal-link control is not available in your version.
Frequently Asked Questions
Can I hyperlink just one word inside a sentence in an Excel cell?
No. Excel’s normal hyperlink command applies to the whole cell, not selected characters inside it. Put that word in a separate cell or use a separate text box with a hyperlink if it needs to look like part of a sentence.
Can the cell show a word instead of the full web address?
Yes. Type the word or label in the cell, open the link dialog, and enter the URL in the Address field. The cell displays its label while the URL remains the destination.
How do I make the link open another sheet or cell?
Select the label cell, open Insert > Link, and choose Place in This Document. Pick the worksheet and target cell, then confirm. The exact dialog layout can vary between desktop Excel and the web version.
Why does the link not open when I click once?
Excel commonly uses a click to select the cell. On Windows, use Ctrl+click or right-click and choose Open Hyperlink. On Mac or in Excel for the web, use the link’s context menu if a regular click selects rather than opens it.
Can I change the destination but keep the same word?
Yes. Select the linked cell, press Ctrl+K on Windows, replace the Address value, and confirm. The displayed label can stay as it is. On Mac, use Command+K to edit the link.
Will links keep working if I email the workbook?
Web links usually work for recipients who have internet access and can visit the page. Links to private sites, local files, or shared documents depend on permissions and file locations, so test the workbook from the recipient’s likely setup.
Related
- Insert a Blank Checkbox in Word: Printable or Clickable
- Google Sheets INDEX MATCH Formula: How to Use It Right
- INDEX MATCH in Google Sheets: Search Another Sheet
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Shared Mailbox in Outlook on a PC: Add It Step by StepTo add a shared mailbox in Outlook on a Windows PC, first ask your Microsoft 365 or Exchange…
- Untitled Spreadsheet in Google Sheets: What It MeansAn “Untitled spreadsheet” in Google Sheets is a new spreadsheet file that has not been given a custom…
- Remove Duplicates in Excel: A Practical Step-by-Step GuideTo remove duplicate rows in Excel for Microsoft 365 on Windows, select your data, choose Data > Remove…
- Flip Paste in Excel: Turn Rows Into Columns EasilyTo flip-paste a range in Excel for Microsoft 365 on Windows, select and copy the cells, click a…
- Excel Get Data From CSV Files in a Batch: Power QueryYes. In Excel for Microsoft 365 on Windows, go to Data > Get Data > From File >…
- Track Changes in Word: How to Review and Accept EditsTo use Track Changes in Microsoft Word, open the Review tab and select Track Changes, then edit the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.