How To Remove a Hyperlink in Excel (Instructions and Tips)

By Indeed Editorial Team

Published March 25, 2022

The Indeed Editorial Team comprises a diverse and talented team of writers, researchers and subject matter experts equipped with Indeed's data and insights to deliver useful tips to help guide your career journey.

If you've ever typed a URL into a spreadsheet, you may notice that it turns blue and becomes underlined when you press "Enter." You've created what's known as a hyperlink, or a shortcut that directs you to another file or website when you click on it. This feature can be useful, but knowing how to remove hyperlinks can help you have more control over your spreadsheets. In this article, we teach you how to remove a hyperlink in Excel and offer expert tips.

What is a hyperlink in Excel?

A hyperlink in Excel is a shortcut that takes the user to another location when they click on it. You can attach hyperlinks to cells, and they may lead to another cell in the spreadsheet, another workbook or an external website. Hyperlinks appear automatically when you paste a link into a cell and press "Enter" on your keyboard.

Users can also create hyperlinks by selecting a cell, clicking the "Insert" tab and clicking "Link." In this tab, you select which document you want to link to or paste a link to an external website. If you want the cell to display something other than the link's URL, you may customize the "Text to display" field. After clicking "OK," the hyperlink appears in the cell and leads to a new page when you click on it.

Related: How To Make a Hyperlink (With Definition, Steps and Tips)

How to remove a hyperlink in Excel via the drop-down menu

Here are instructions for removing an individual hyperlink in a single cell:

  1. Right-click on a cell that contains a hyperlink.

  2. Choose "Remove Hyperlink" from the dropdown menu.

  3. Confirm that the cell's text is no longer blue and underlined.

Related: How To Create a Hyperlink in Gmail in 5 Steps (Plus Benefits)

How to remove a hyperlink in Excel via the "Editing" group

Here's another way to remove a hyperlink in a single cell via the "Editing" feature:

  1. Select a cell with a hyperlink.

  2. Click on the "Home" tab.

  3. Click on the "Editing" button.

  4. Click "Remove Hyperlink."

How to remove hyperlinks in multiple cells

Here's how to remove hyperlinks in multiple cells:

  1. Click on a cell with a hyperlink you want to remove.

  2. If the other cells with hyperlinks you want to remove are adjacent to the first cell, drag your mouse across these cells to highlight them.

  3. If the other cells are separate from the first cell, hold the "Ctrl" key while clicking on each cell individually.

  4. Right-click on a highlighted cell.

  5. Click "Remove Hyperlinks."

How to remove all hyperlinks in a spreadsheet

You may want to ensure that none of the text in your spreadsheet leads to external pages. Here's how to remove all hyperlinks simultaneously:

  1. Highlight all cells by clicking on the triangle in the upper left corner of the spreadsheet.

  2. Right-click anywhere on the sheet.

  3. Select "Remove Hyperlinks."

How to disable automatic hyperlinks in Excel

Pasting a link into a cell and pressing "Enter" automatically turns the text into a hyperlink. While this feature can be useful, you may want the link to appear as standard text without it serving as a shortcut to a different spreadsheet or website. Here are instructions for disabling automatic hyperlinks:

  1. Open any workbook.

  2. Click "File" at the top left corner of the page.

  3. Click "Options" at the bottom left corner of the page.

  4. Click the "Proofing" tab in the left menu.

  5. Click the "AutoCorrect Options" button.

  6. Click the "AutoFormat As You Type" tab.

  7. Uncheck the box next to "Internet and network paths with hyperlinks."

  8. Click "OK" twice.

Related: How To Search in Excel in 5 Steps (Plus Tips)

How to edit a hyperlink

In some cases, it may be more efficient to edit a hyperlink than delete it altogether. For instance, you might want to adjust the display text or update the link. Here are instructions for editing a hyperlink in Excel:

  1. Select a cell with a hyperlink.

  2. Click "Edit Hyperlink" in the drop-down menu.

  3. Click on the "Text to display" field to edit the text that appears in the cell. If you want the URL to appear in the cell, you can leave this field blank.

  4. Click on one of the "Link to" options and enter the desired URL or select the desired file location.

  5. Click "OK."

FAQ about hyperlinks in Excel

Here are some FAQs about hyperlinks in Excel:

What do the hyperlinked colors mean?

By default, the program makes all newly hyperlinked text blue. Hyperlinks turn purple when you click on the link. You may change Hyperlinks typically appear in blue. If you want to change the color, you can change the settings by going to "Page Layout" > "Colors" > "Create New Theme Colors." In this window, select new colors for "Hyperlink" and "Followed Hyperlink."

Related: 10 Top Excel Accounting Formulas and Functions (With Examples)

How do I select cells with hyperlinks without triggering the URL?

As you edit a spreadsheet that has hyperlinks, you may want to click on cells without going to a new document or website. You can click the cell without opening its link by using one of these methods:

  • Ensuring you click on white space in the cell

  • Right-clicking on the cell, then left-clicking

  • Left-clicking on the cell and holding the mouse down for about a second

Related: How To Multiply in Excel (With Benefits, Examples and Tips)

What is the hyperlink formula?

The hyperlink formula is a function that allows you to automatically insert shortcuts to other documents or websites. You can enter this formula by typing "=HYPERLINK" into any cell and pressing "Enter." The first field is the link location, and the second field is the text that you want the cell to display. For instance, imagine that cell A1 contains the text "Click here" and cell B1 contains the link "example.com." Typing "=HYPERLINK(B1, A1)" into cell C1 would create a "Click here" hyperlink that leads to the link "example.com."

Please note that none of the companies mentioned in this article are affiliated with Indeed.

Explore more articles