|
Home > Formulas > Lookup > Hyperlink Excel Hyperlink Examples-Tips-Fixes
|

Jump To
In a Microsoft Excel worksheet, you can create a hyperlink in any cell. Then, click that hyperlink to go to the specified location.
Here are four ways create a hyperlink in an Excel spreadsheet
Details on each method are in the sections below.

If you type a valid website address in a cell, Excel should automatically create a hyperlink, when you press Enter. For example,
The text changes to a hyperlink, and you can click the link to go to the Contextures website.
Tip: If you want to stop hyperlinks from being automatically created in Excel, follow the instructions here.

For more control over hyperlinks, use the Insert Hyperlink command
When the Insert Hyperlink dialog box opens:
Tip: For details on the settings, go to the Down the Rabbit Hole section

If you're creating hyperlinks within an Excel file, the quickest and easiest method is to use drag and drop. For example, you could create a table of contents sheet (TOC), in a workbook, with links to other sheets.
I show the steps in this short video, and there are written steps in the Drag and Drop section below.
Instead of creating hyperlinks manually, you can use the HYPERLINK function to build clickable links.
This video shows a quick overview of how you can create clickable hyperlinks with HYPERLINK formulas.
There are written steps and examples on the Excel HYPERLINK Function page.
In this example, the Excel file has a table of contents sheet (TOC), a Sales sheet, and an Expenses sheet.
Follow the steps below, to create drag and drop hyperlinks on the TOC sheet, for Sales and Expense.
To add the Sales sheet to the Table of Contents, follow these steps:

To drag the Sales Report cell to a different sheet, follow the steps below.


A hyperlink will appear in the cell, with the text from the original cell - Sales Report.
Click that link to go to the hyperlink's destination.

To create a Table of Contents hyperlink for the Expenses sheet, repeat the same steps, to drag the Expense sheet heading onto the TOC sheet

If you have trouble dragging to a different sheet, drag to a nearby blank cell, then cut and paste onto the other sheet.
This animated gif shows those steps.

If you only have a few hyperlinks to remove, follow the steps below, to remove the hyperlinks manually.
I show the steps in this very short video.
In Excel 2007 and earlier versions, the right-click menu doesn't have a Remove hyperlinks command.
I show the steps in this very short video.
Follow these steps to make the pointing hand appear anywhere in a hyperlink cell, and see how to select a hyperlinked cell, without following the link.
If a wide cell contains a short hyperlink, the pointing hand will only appear when it's over the text, not in the empty space. To fix that:

If you need to select a hyperlink cell, perhaps to edit the text, without following the link:
If you don't want hyperlinks automatically created when you type a website address, you can turn the hyperlinking feature off.
To see a quick overview of how you can stop automatic hyperlinks from being created automatically, you can watch this short video. The written instructions are below the video.
To turn the hyperlink option off, follow these steps:

In some versions of Excel, you might see a security warning (shown below), when you click on a worksheet hyperlink.
Every morning, I see these messages after clicking on worksheet links that I know are safe, such as the Canadian government's weather forecast, and pages on my own website!
For example, the screen shot below shows the message I see after clicking a link to the Microsoft site.
Here is the text shown in the warning message:

These warnings are part of Microsoft's security system, and there's no setting in Excel where you can turn those safety warnings off.
Also, there's no list where you can "whitelist" specific websites, to assure Excel that they're safe. No matter how many times you've previously clicked a link, you'll get the warning message.
Click one of the buttons, based on your trust of the destination website:
When you create a hyperlink in Excel, it has a default format:

You can change the cell formatting for an individual hyperlink, like the red, bold, italic example below.
But that cell formatting can disappear easily, if you if you click the link or update it.

There are two places where you can control the overall hyperlink formatting:
To change the Hyperlink cell style in the current workbook, follow the steps below
The Style dialog box opens, showing the Style name at the top. In the Style includes section, only the Font setting has a check mark

On the worksheet, the Hyperlink cell has changed to Bold font.
The Followed Hyperlink was NOT affected by the cell style change.

Thanks to Christian Back (LinkedIn profile), who alerted me to this helpful new feature in threaded comments.
In Excel 365, you can add clickable hyperlinks in Excel's threaded comments. That makes it easy to provide links to related information, without filling the worksheet cells with hyperlinks.
If you're not familiar with threaded comments, see the basic steps on my Threaded Comments page. You can also download the Comment Hyperlinks sample file, in the download section, at the end of this page.
To use a threaded comment hyperlink, follow these steps:

In some cases, the Ctrl + click doesn't work, when I use the hyperlink in the cell's pop-up threaded comments.
If that happens in your version of Excel too, you can open the Comments Taskpane, and then Ctrl + Click the hyperlinks there.
For details on opening the taskpane, and adjusting it, go to the Threaded Comments macros page.

In some versions of Excel, you might have a problem with your hyperlinks, when you create a PDF file from your Excel workbook.
In the PDF file, some of your hyperlinks might not be clickable, if:
For example, the PDF hyperlink won't work if the friendly name is "Click for info", and the link location is google.com
To avoid this problem, either:
In one of my workbooks, I need to make a couple of entries at the start of each month. To avoid forgetting that crucial step, I made a hyperlink that only shows up on the first of the month!
There are detailed instructions on my Contextures blog, and the Hidden Hyperlink sample file is in the download section, below.

In this section, you'll find related Excel tips, shortcuts, skills, and details. These things are nice to know, but not essential, so you can skip this section, and get back to work. Or dive in, for some extra Excel fun and knowledge!
--1) Insert Hyperlink Dialog Box
--2) Insert Hyperlink - Text to Display
--3) Insert Hyperlink - Link To
The Insert Hyperlink dialog box shows hyperlink settings to customize your worksheet hyperlinks.
First, at the left side of the Insert Hyperlink window, click the link type that you need.
The other hyperlink setting options will change, based on which link type you select.
In the screenshot below, I've selected Place in This Document.

At the top of the Insert Hyperlink dialog box, there is a "Text to Display" box. Sometimes you can type in that box, and sometimes you can't!

When you point to a cell that contains a hyperlink, its ScreenTip appears.

In the Insert Hyperlink dialog box, you can enter your own text for the ScreenTip, or leave this setting empty.
To add your own text for the ScreenTip:

At the top of the Insert Hyperlink dialog box, there is a "Text to Display" box. What you see in the Text to Display box depends on what is in the cell where you're creating the hyperlink.
Here are the 4 different types of content that affect the Text to Display option, with details below:
If the selected cell contains text, that text will appear in the Text to Display box.

If the selected cell is empty, the sheet name, and cell A1 will appear in the Text to Display box.

If the selected cell contains a real number, you will not be able to edit the Text to Display box.
The box contents are dimmed out, and it shows this message: < < Selection in Document > >
If you want to edit the Text to Display:
OR
If the selected cell contains a "text" number (formatted as text, or starting with an apostrophe), that text number will appear in the Text to Display box.

Use this option, if you want to make it easy for people to open another Excel file, or go to a web page, for more information.

Most of the time, I use the Place in This Document option.
It lists all of the sheets and named ranges in the active Excel file.

Don't miss my monthly Excel newsletter! You'll get quick tips, article links, and a bit of fun. Add your email, and click Sign Up.
Next, when you get my reply, click the Confirm button. I add this step to protect you from spam!
Last updated: August 20, 2026 2:02 PM