Home > Formulas > Lookup > Hyperlink

Excel Hyperlink Examples-Tips-Fixes

Debra Dalgleish - Contextures

Quick ways to create hyperlinks, how to stop automatic hyperlinks, and more hyperlink tips! Get the sample Excel files, and see the steps in short videos.

Also see HYPERLINK Function and hyperlink macros

text to display for cell with text

1) Create Excel Hyperlinks

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.

hyperlink drag 04

1.1) Type a Website URL

If you type a valid website address in a cell, Excel should automatically create a hyperlink, when you press Enter. For example,

  1. In cell B3, type the address of the Contextures website: https://www.contextures.com
  2. Press Enter

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.

hyperlink typed in cell

1.2) Insert Hyperlink

For more control over hyperlinks, use the Insert Hyperlink command

  • Select the cell where you want the hyperlink
  • Next, use the keyboard shortcut - Ctrl + K
    • OR on the Excel Ribbon, click the Insert tab, and click the Hyperlink command

When the Insert Hyperlink dialog box opens:

  • Select a Link To option at the left, e.g. Place in This Document
  • Fill in the hyperlink settings at the right.

Tip: For details on the settings, go to the Down the Rabbit Hole section

choose a links to type

1.3) Drag and Drop Hyperlinks

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.

1,4) Excel HYPERLINK Function

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.

2) Drag and Drop Hyperlinks

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.

2.1) Save the Excel File

  • First, save the workbook, if it hasn't been saved yet.
  • In a new workbook, that hasn't been saved, this drag and drop technique won't work.

2.2) Start the Drag and Drop

To add the Sales sheet to the Table of Contents, follow these steps:

  • Go to the Sales sheet, and click on the heading in cell A1
  • Point to the cell's border, and press the right mouse button.

select heading cell and point to border

2.3) Drag to a Different Sheet

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

  • While you drag, press the Alt key, and down to the TOC sheet's tab.
  • When the pointer is on the sheet tab, the TOC is activated
  • select heading cell and point to border

2.4) Finish the Drag and Drop

  • Once the TOC sheet is activated, release the Alt key, and continue dragging, up to cell B4, where the hyperlink should go
  • Then, release the right mouse button, and in the popup menu, click Create Hyperlink Here

    click the Create Hyperlink command

2.5) Use the Hyperlink

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.

click the Hyperlink to go to the Sales sheet

2.5) Create More Hyperlinks

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

add another hyperlink

2.6) Drag and Drop Problems

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.

drag and drop hyperlinks

3) Remove Hyperlinks

If you only have a few hyperlinks to remove, follow the steps below, to remove the hyperlinks manually.

  1. Select the cell(s) that contain hyperlinks
  2. Right click on any selected cell
  3. Click Remove hyperlinks

I show the steps in this very short video.

3.1) In Excel 2007 and earlier versions:

In Excel 2007 and earlier versions, the right-click menu doesn't have a Remove hyperlinks command.

  • Instead, you can copy and paste the cells as values.

I show the steps in this very short video.

4) Point to Hyperlinks

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.

4.1) Show the Pointing Hand

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:

  • Select the cell(s)
  • On the Home tab of the Excel Ribbon, click the Wrap Text command.

hyperlink in full cell

4.2) Select a Hyperlink Cell

If you need to select a hyperlink cell, perhaps to edit the text, without following the link:

  • Point to the cell, and press the left mouse button for a couple of seconds.
  • The pointer will change to a big white plus sign, to show that the cell was selected.
  • You can now edit the hyperlink cell

5) Stop Automatic Hyperlinks in Excel

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:

  1. On the Excel Ribbon, click the File tab, then click Options
  2. Click the Proofing category, and click the AutoCorrect Options button
  3. On the AutoFormat As You Type tab, remove the check mark from Internet and network paths with hyperlinks
  4. Click OK, twice, to close the dialog boxes

hyperlink options

6) Hyperlink Security Warning

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!

6.1) Warning Message Text

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:

  • Title: Advanced Threat Protection - Safe Links
  • Message: Verification of this link failed due to an error.
  • Address: https://www.microsoft.com/
  • Buttons:
    • Cancel navigation (or press Esc key)
    • Skip verification (or press Enter key)

Hyperlink security warning - Advanced Threat Protection - Safe Links

6.2) Cannot Turn Warnings Off

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:

  • Safe Link: If you click a hyperlink that you know is safe, click the Skip verification button, to continue to the website. Or, tap the Enter key on your keyboard.
  • Unknown Link: If you aren't sure that the link is safe, click the Cancel navigation button, or tap the Esc key on your keyboard.

7) Hyperlink Format Colour

When you create a hyperlink in Excel, it has a default format:

  • Hyperlink: At first, a hyperlink's font is blue and underlined
  • Followed Hyperlink: After you click (follow) a hyperlink, its colour changes to purple

default formatting for Excel hyperlinks

7.1) Cell Formatting Problem

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.

cell formatting applied to Excel hyperlinks

7.2) Overall Hyperlink Formatting

There are two places where you can control the overall hyperlink formatting:

  • Cell Styles: Changes affect the current workbook only.
    • I use this method, and there are steps in the next section
  • Themes: Changes affect all Office files on your computer that use the theme.

7.3) Modify Hyperlink Cell Style

To change the Hyperlink cell style in the current workbook, follow the steps below

  • Select any cell that contains a hyperlink
  • On the Excel Ribbon, go to the Home tab
  • In the Styles group, click Cell Styles
  • In the Data and Model section, right-click Hyperlink, then click Modify

7.3.1) Style Dialog Box

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

  • Click the Format button, at the top right

7.3.2) Format Cells Dialog Box

  • When the Format Cells dialog box opens, go to the Font tab
  • On the Font tab, select the settings that you want for Font, Underline, Effects, Font Style, Color, and Size.
  • The Preview window shows the revised Hyperlink style.
  • To complete the changes, click the Ok button, then click OK in the Style box.

Hyperlink style in Format Cells dialog box Font tab

7.3.3) Revised Hyperlink Cell Style

On the worksheet, the Hyperlink cell has changed to Bold font.

The Followed Hyperlink was NOT affected by the cell style change.

  • To change the Followed Hyperlink cell style, follow the steps above, and right-click on the Follow Hyperlink style, then modify its settings.

cell formatting applied to Excel hyperlinks

8) Add Hyperlinks in Threaded Comments

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.

8.1) Follow Hyperlink in Comment

To use a threaded comment hyperlink, follow these steps:

  • Point to a cell that has a purple marker, at the top right corner
  • When the threaded comment appears, point to a hyperlink in one of the comments
  • On your keyboard, press the Ctrl key, then click the hyperlink, to follow that link
  • Note: After clicking the hyperlink, you might see a warning message -- Advanced Threat Protection - Safe Links. See notes on that warning, above.

clickable hyperlink in threaded comment

8.2) See Hyperlinks in Comments Pane

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.

  • Note: After clicking the hyperlink, you might see a warning message -- Advanced Threat Protection - Safe Links. See notes on that warning, above.

clickable hyperlink in threaded comment task pane

9) Clickable Hyperlinks for Export to PDF

In some versions of Excel, you might have a problem with your hyperlinks, when you create a PDF file from your Excel workbook.

9.1) Links Not Clickable in PDF

In the PDF file, some of your hyperlinks might not be clickable, if:

  • the hyperlink was created with an Excel formula
  • the "friendly name" for the hyperlink is different from the link location

For example, the PDF hyperlink won't work if the friendly name is "Click for info", and the link location is google.com

9.2) Avoid the Problem

To avoid this problem, either:

  • manually enter the hyperlinks, instead of using the HYPERLINK function
  • or, omit the friendly name argument, so the full location link is displayed in the cell

10) Hide Hyperlink Until Needed

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!

  • The hyperlink goes to the Month End sheet, where the entries are needed
  • On first day of month, conditional formatting changes the hyperlink's cell colour and font colour, to make it visible

There are detailed instructions on my Contextures blog, and the Hidden Hyperlink sample file is in the download section, below.

Hide Hyperlink Until Needed

11) Get the Excel Files ✅

  1. Create Hyperlinks: To see the Create hyperlink examples, you can download the Excel Hyperlink sample file. The zipped Excel workbook is in xlsx format, and does NOT contain macros.
  2. Drag and Drop: Download the Table of Contents sample file, to follow along with the Table of Contents video and written steps
  3. Comment Hyperlinks: Get the sample file for Excel hyperlinks in threaded comments. The zipped Excel workbook is in xlsx format, and does NOT contain macros.
  4. Hidden Hyperlink: Get the sample file for hidden hyperlinks. Use conditional formatting and formulas, to hide a worksheet hyperlink. On first day of month, hyperlink is visible, with link to Monthly Update sheet. The zipped Excel workbook is in xlsx format, and does NOT contain macros.

🐰 12) Down the Rabbit Hole 🐰

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

12.1) Insert Hyperlink Dialog Box

The Insert Hyperlink dialog box shows hyperlink settings to customize your worksheet hyperlinks.

  • Important: Be sure to select a Link To type first, and then fill in the other settings.

12.1.1) Link To

First, at the left side of the Insert Hyperlink window, click the link type that you need.

  1. Existing file or Web Page
  2. Place in This Document
  3. Create New Document
  4. E-mail Address

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.

choose a links to type

12.1.2) Text to Display

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!

  • There are details on the Text to Display box in section below

text to display for cell with text

12.1.3) Add a ScreenTip (Optional)

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

screentip for hyperlink on worksheet

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

  • NOTE: If you leave the ScreenTip empty, the full hyperlink address will appear in the ScreenTip.

To add your own text for the ScreenTip:

  • In the Insert Hyperlink window, click the ScreenTip button
  • Type the text for the screen tip
  • Click OK

hyperlink screen tip

12.2) Insert Hyperlink - Text to Display

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:

  1. Text in Cell
  2. Empty Cell
  3. Number in Cell
  4. "Text" Number in Cell

12.2.1) Text in Cell

If the selected cell contains text, that text will appear in the Text to Display box.

  • You can edit the Text to Display text
  • The revised text will appear in the cell, after you create the hyperlink.

text to display for cell with text

12.2.2) Empty Cell

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

  • You can edit the Text to Display text
  • The revised text will appear in the cell, after you create the hyperlink.

text to display for cell with no text

12.2.3) Number in Cell

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 > >

  • NOTE: You will see the same message if you're adding a hyperlink to a shape on the worksheet.

If you want to edit the Text to Display:

  • Create the hyperlink, and then change the value in the cell

OR

  • Close the Insert Hyperlink dialog box
  • Change the cell's number to text (format as text, or type an apostrophe before the number)
  • Open the Insert Hyperlink dialog box again, and the Text to Display Box will be editable
text to display dimmed out and says < < Selection in Document > >
Text to Display dimmed out and says < < Selection in Document > >

12.2.4) "Text" Number in Cell

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.

  • You can edit the Text to Display text
  • The revised text will appear in the cell, after you create the hyperlink.

text to display for cell with text number

12.3) Insert Hyperlink - Link To

12.3.1) Existing File or Web Page

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.

  • In the Link To list, click on Existing File or Web Page
  • To link to an existing file, use the folder navigation, to find and select the file that you need
    • OR, to link to a web page, type its URL in the Address box

enter the web site address

12.3.2) Place in This Document

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.

  • Click on a sheet name, and then type a specific cell reference where the hyperlink should go to.
  • Or, click on a range name, to go to that range.

choose a links to type

Get Monthly Excel Tips!

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!

More Tutorials

Pivot Table Hyperlinks

SUM Functions  

VLOOKUP   

Lookup - 2 Criteria

INDEX and MATCH   

HTML Code, Create

Count Functions

INDIRECT Function  

 

 

 

Last updated: August 20, 2026 2:02 PM