The two ways to add a hyperlink in Excel

You can add a hyperlink in Excel in two ways: by right-clicking a cell and choosing the hyperlink option, or by using the keyboard shortcut Ctrl+K (on Windows) or Command+K (on Mac). Both methods open the same dialog box where you type or paste the web address you want to link to.

The right-click method works when you have a cell selected and want to turn its contents into a clickable link. The keyboard shortcut is faster if you add hyperlinks often. Either way, Excel lets you choose whether the link text shows the full web address or a shorter label — so a cell can display "Company website" while actually linking to a long URL.

Key Takeaways

  • Right-click a cell and select "Link" (Windows) or "Edit Link" (Mac), or press Ctrl+K or Command+K to open the hyperlink dialog.
  • You can link to a web address, another sheet in the same workbook, a specific cell location, or an email address.
  • The display text (what readers see) can be different from the actual link destination, so "Click here" can point to a long URL.
  • Hyperlinks in Excel are blue and underlined by default, but you can change their color by modifying the cell formatting.
  • Hyperlinks only work when you hold Ctrl and click them; a regular click just selects the cell.

Step-by-step: adding a hyperlink to a website

Start by clicking the cell where you want the hyperlink to appear. Type the text you want readers to see — for example, "Annual Report" or "Contact Us". Then right-click the cell. On Windows, select "Link" from the menu. On Mac, select "Edit Link". A dialog box will open.

In the dialog box, paste or type the full web address in the field labeled "Address" (Windows) or "URL" (Mac). If you want the link text to be different from the address, leave the display text as you typed it. If you want to change it, look for a field called "Display text" or "Text to display" and type your new label there. Click OK, and the hyperlink is created.

Test the link by holding Ctrl (Windows) or Command (Mac) and clicking the cell. Your web browser should open to the address you entered. If it does not, double-click the cell to edit it and check that the address is spelled correctly and includes http:// or https:// at the beginning.

Linking to other sheets and cells within the same workbook

You can link to a different sheet in the same Excel file, or to a specific cell on that sheet. This is useful when your spreadsheet has multiple tabs and you want readers to jump between them without scrolling.

Right-click the cell and open the hyperlink dialog as before. Instead of typing a web address, look for an option called "Place in This Document" (Windows) or a similar field for internal links (Mac). Select the sheet name from the list, then type the cell reference — for example, A1 or B15 — if you want the link to jump to a specific location. Type your display text and click OK.

Creating email links

You can create a hyperlink that opens the reader's email program and starts a new message to a specific address. Right-click the cell and open the hyperlink dialog. Look for an option labeled "Email Address" or similar. Type the email address you want to link to, and optionally add a subject line in the "Subject" field if your version of Excel offers it.

Type the display text — usually something like "Email us" or a department name — and click OK. When someone Ctrl+clicks the link, their default email program opens with a new message addressed to that email address. This saves readers from having to copy and paste an address.

Changing how hyperlinks look

By default, Excel shows hyperlinks in blue and underlined. If you want to change the color or remove the underline, select the cell with the hyperlink and use the font color and underline buttons in the toolbar, just as you would for any other text. You can also right-click the cell, choose "Format Cells", and adjust the font color and style from there.

Keep in mind that changing the appearance of a hyperlink does not change how it works — it only changes what readers see. A hyperlink that looks like regular black text is still a hyperlink and still requires Ctrl+click to follow.

Removing or editing a hyperlink

To remove a hyperlink and keep the text, right-click the cell and select "Remove Link" (Windows) or "Delete Link" (Mac). The text stays in the cell, but it is no longer clickable.

To edit a hyperlink without changing the text, right-click the cell and select "Edit Link" (Windows) or "Edit Link" (Mac). The hyperlink dialog opens again, and you can change the address or the display text. Click OK to save your changes.

When hyperlinks make a spreadsheet harder to use

Hyperlinks are most useful when your spreadsheet is shared digitally and readers will view it on a screen. If you print the spreadsheet, hyperlinks do not print as clickable — they just show the display text. Readers looking at a printed page cannot follow the link.

Hyperlinks can also make a spreadsheet confusing if there are too many of them, or if the link destination is not obvious from the display text. A cell that says "Click here" does not tell readers where they are going. A cell that says "2024 Budget Proposal" or "Email support team" is clearer and more useful.

Frequently Asked Questions

Why does my hyperlink not work when I click it?

Hyperlinks in Excel require you to hold Ctrl (Windows) or Command (Mac) while clicking. A regular click just selects the cell. If you hold Ctrl and click and nothing happens, the address may be misspelled or missing http:// or https:// at the start. Right-click the cell, select "Edit Link", and check the address.

Can I link to a specific cell in a different workbook?

Yes, but the other file must be saved and closed first. Open the hyperlink dialog, choose "Place in This Document" or the equivalent, and look for an option to link to an external file. You will need to browse to the file and then select the sheet and cell. The link will include the file path, so moving the file to a different folder may break the link.

How do I change the color of a hyperlink?

Select the cell with the hyperlink and use the font color button in the toolbar, or right-click and choose "Format Cells" to access more color options. You can make hyperlinks any color you want, though blue is standard and readers expect it.

What happens if I copy a cell with a hyperlink to another sheet?

The hyperlink copies along with the cell. If the link points to a website or email address, it works the same way on the new sheet. If it points to a cell in the original sheet, it still points to that same cell, not to a corresponding cell on the new sheet.

Can I add a hyperlink to a range of cells instead of just one?

Excel hyperlinks are attached to individual cells, not ranges. If you want multiple cells to link to the same place, you can select them all at once, open the hyperlink dialog, and create the link — Excel will explore it to every selected cell at the same time.