The two ways to add a link in Excel

You can add a link to an Excel cell in two ways: by using the keyboard shortcut Ctrl+K (Windows) or Cmd+K (Mac), or by right-clicking the cell and selecting "Link" from the menu. Both methods open the same dialog box where you type or paste the web address you want to link to. The link then appears as blue underlined text in that cell, and anyone who clicks it will be taken to that address.

The keyboard shortcut is faster if you are adding multiple links. The right-click method works if you prefer using the menu, or if the shortcut does not work on your keyboard layout. Either way, the result is the same: a clickable link inside your spreadsheet.

Key Takeaways

  • Press Ctrl+K (Windows) or Cmd+K (Mac) to open the link dialog, then type or paste the web address and click OK.
  • You can link to a website, an email address, or another cell or sheet within the same workbook.
  • The link text (what shows in the cell) can be different from the actual address it points to.
  • To edit or remove a link later, right-click the cell and choose "Edit Link" or "Remove Link".

Adding a web link step by step

Click the cell where you want the link to appear. Press Ctrl+K (or Cmd+K on Mac). In the dialog box that opens, you will see a field labeled "Address". Type or paste the full web address — for example, https://www.example.com. If you want the link text to say something other than the address itself, type that in the "Display Text" field. Click OK.

The cell now shows the link text in blue and underlined. When you or someone else opens the spreadsheet and clicks that cell, it will open the web address in your default browser. If you did not enter display text, the cell will show the full address you entered.

Linking to an email address

To create a link that opens someone's email program, use the same Ctrl+K shortcut. In the Address field, type mailto: followed by the email address with no space — for example, mailto:person@example.com. You can add display text like "Email us" so the cell does not show the raw email address.

When someone clicks this link, their default email program will open with a new message addressed to that email. This is useful if you are sharing a spreadsheet and want people to be able to contact you or a team member without having to copy and paste an address.

Linking to another sheet or cell in the same workbook

You can link to a different sheet in the same Excel file, or to a specific cell on that sheet. Press Ctrl+K, then in the Address field, type the sheet name followed by an exclamation mark and the cell reference — for example, Sheet2!A1 or Summary!B5. If the sheet name has spaces, put it in single quotes: 'Sheet 2'!A1.

This is helpful when you have a large workbook with multiple sheets and want to let people jump between them. You can also link to a named range if you have created one, which makes the link easier to read and more stable if rows or columns are added later.

Changing the link text without changing the address

The text that appears in the cell does not have to match the address it points to. When you create a link, the "Display Text" field lets you type whatever you want — "Click here", "Our website", "Q3 Report", anything. The actual address stays hidden behind that text.

This is useful for keeping your spreadsheet clean and readable. Instead of a cell full of a long web address, you can show a short label. To change the display text later, right-click the cell, choose "Edit Link", and update the Display Text field. The address itself will not change unless you edit that field too.

Editing and removing links

To change where a link points, right-click the cell and select "Edit Link". The same dialog box opens. You can change the address, the display text, or both. Click OK when you are done. To remove a link entirely while keeping the text in the cell, right-click and choose "Remove Link". The text stays, but it is no longer blue or clickable.

You can also select a cell with a link and press Ctrl+Shift+F9 (Windows) to break all links in the spreadsheet at once, though this is less common. If you want to delete the cell content entirely, just press Delete as you would with any other cell.

Why links matter in shared spreadsheets

Links make spreadsheets more useful when you are sharing them with others. Instead of asking people to copy a web address or remember a file location, you can embed the link directly. A budget spreadsheet might link to the source data. A project tracker might link to each task's details page. A contact list might link to email addresses or websites.

Links also help you navigate your own large workbooks. If you have a summary sheet at the top, you can link each row to the detailed sheet below it. This saves time scrolling and makes the spreadsheet feel more organized. Just remember that if you move or delete the file a link points to, the link will break — it will still be clickable but will show an error when clicked.

Frequently Asked Questions

Can I link to a file on my computer instead of a website?

Yes. In the Address field, type the full file path — for example, C:\Users\YourName\Documents\Report.pdf on Windows, or /Users/YourName/Documents/Report.pdf on Mac. Use the folder icon in the dialog to browse for the file if you are not sure of the exact path. The link will open that file when clicked, as long as the file stays in that location.

What happens to links when I save the file as PDF?

Links stay clickable in a PDF. When you save an Excel file as PDF, the links convert to PDF links and work the same way — web links open in a browser, email links open your email program, and file links open the file. However, links to other sheets in the workbook become broken because a PDF is a single flat document, not a multi-sheet file.

Can I make a link open in a new browser tab instead of the current one?

Excel does not have a built-in setting for this. When someone clicks a web link in Excel, it opens in their default browser using the browser's normal behavior — usually the same window or tab. You cannot control this from Excel itself. The behavior depends on the person's browser settings.

How do I link to a specific part of a web page?

If the web page has anchor links (sections marked with #), you can link directly to them. Type the full address with the anchor at the end — for example, https://www.example.com/page#section2. When someone clicks the link, the page opens and scrolls to that section. Not all websites use anchors, so this only works if the page creator set them up.

Can I add a link to a picture or shape instead of text?

Yes. Click the picture or shape, then press Ctrl+K. The link dialog opens. Type the address and click OK. The picture or shape is now clickable and will open that link. The image itself does not change appearance, but it becomes interactive — useful for creating buttons or navigation elements in your spreadsheet.