How To Insert And Remove A Hyperlink In Excel (Ultimate Guide)

Written by co-founder Kasper Langmann, Microsoft Office Specialist.

In most programs, a hyperlink is simple – it brings you to a web page!

Inserting it is just as simple: you highlight the text you want to link, click a button, and enter the URL.

But Excel’s hyperlinks are way more powerful than that.

Yes, they can open a browser window and bring you to a specific page.

But they can also bring you to a specific place in a file, open a new file, or go to another spreadsheet entirely.

Cool, right 🙂 ?

Keep reading!

Get your FREE exercise file

It’s easy to practice inserting hyperlinks into your Excel spreadsheets, but we whipped one up to help you practice.

Download it now and follow along!

Download the FREE Exercise File

Download exercise file

Linking to URLs (websites)

When you think of a hyperlink, you probably think of a link to a web page.

That’s the first use of Excel hyperlinks that we’ll look at.

Open up the example workbook and click on the cell that says “Link to a URL.”

Then click the Insert tab in the Ribbon and click Link.

link-button

You can also use the Excel keyboard shortcut for inserting a link, Ctrl + K.

This shortcut works in many apps, so it’s a good one to know.

Kasper Langmann, Co-founder of Spreadsheeto

The Insert Hyperlink dialog box will appear.

insert-hyperlink

There’s a lot going on in this small box, so we’ll take it one step at a time.

For our purposes, all we need to do is select the Existing File or Web Page button on the left (it should be selected already) and add the URL (we’ll use https://spreadsheeto.com/) to the Address box at the bottom:

insert-url-link

Click OK, and the text will change in color and become a link! Just click it to go to the Spreadsheeto main page.

linked-cell

Linking to an email address

Creating a link that will open in a user’s default email program is a great way to share your contact information.

And it’s super easy to add to your spreadsheet.

Just highlight a cell, hit Ctrl + K, and enter the email address and default subject line you want:

insert-email

Exactly what happens next depends on the user’s default email client. The link will probably open Outlook or a browser tab with Gmail.

From there, all they have to do is fill in the body and send.

Kasper Langmann, Co-founder of Spreadsheeto

Link to a cell in the same spreadsheet

In a very large spreadsheet, it can be helpful to have a table of contents or a quick way to get from one commonly used section to another.

To do that, hit Ctrl + K to bring up the Insert Hyperlink dialog, and select Place in This Document in the left panel:

place-in-this-document

Then select a sheet in the Or select a place in this document field, and enter the cell reference in the box above:

insert-link-this-sheet

To link to a different spreadsheet in the same workbook, select the name of the sheet before typing in the cell reference.

Kasper Langmann, Co-founder of Spreadsheeto

You can also do this by clicking the Lookup & Reference button in the Formulas tab and selecting HYPERLINK. That opens a dialog that lets you click to select a specific cell to link to:

click-to-link

We’ll go over the details of the HYPERLINK function a bit later, so don’t worry too much about that right now.

Kasper Langmann, Co-founder of Spreadsheeto

Also note that you can link to a defined name.

If you’ve created a named range in your spreadsheet, you can link to that range. Just select the defined name from the list in the pane.

Link to a different workbook

Linking to a different spreadsheet is as easy as linking within one.

Press Ctrl + K to open up the links dialog, then select Existing File or Web Page on the left. Use the file explorer to find the file you want to link to:

link-spreadsheet

Then hit OK.

Now, whenever you click on the link, the other file will open.

Pro tip: linking to specified cells in other files

It’s possible to link to a specific cell in another file, but you’ll need to use the HYPERLINK function, which we discuss below.

How to remove a hyperlink

Whether you’ve added a link that you now don’t want, or received a spreadsheet that has irrelevant links, there are many cases in which you might want to remove a hyperlink in Excel.

Fortunately, it’s very easy.

Right-click the hyperlink and select Remove Hyperlink.

remove-hyperlink

Make sure to right-click, or else you’ll immediately follow the link.

Adding screentips

Screentips are messages that pop up when you hover over a link.

Here’s one of the default screentips:

screentip

As you can see, Excel displays the target location of the link, as well as the instructions “Click once to follow. Click and hold to select this cell.”

If you want to add your own screentip, you can do this through the links dialog. Highlight and link and hit Ctrl + K to open the window, then click ScreenTip…

screentip-button

Type in a message, click OK, then click OK again to save your link. Now, when you hover over your link, you’ll see your custom message.

Selecting linked cells

Clicking on a cell with a link in it will take you to wherever that link is pointing.

But what if you just want to select the cell? Or edit it?

The easiest way to do this is to click and hold on the cell. After a moment, your cursor will change from a pointer finger to a cross. If you let go of the mouse button at this point, you won’t follow the link.

select-linked-cell

If you want to edit the link, right-click on the cell and select Edit Hyperlink.

edit-hyperlink

Add links in Excel like a pro

Linking to web pages and other spreadsheets from Excel documents is a very useful thing to know how to do. And when you can tweak all of the related options, you can not only make your links look nice, but provide useful information for your users, too.

It’s a skill that really comes in handy!