• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Clear Hyperlinks in Excel

October 24, 2021 by Andrew Childress
Hyperlink Menu excel

Hyperlinks are a helpful feature, but you might also need to remove and clear them. Here's how to do just that as we learn how to clear hyperlinks in Excel.

A hyperlink in Excel will help you to connect cells in your worksheet to other content. That might be to another sheet, a specific cell, or even an external page like a website.

Hyperlinks are a helpful feature, but you might also need to remove and clear them from your workbook. Let’s learn how to do just that as we learn how to clear hyperlinks in Excel.

How to Clear Hyperlinks in Excel

First, let’s have a quick review of how hyperlinks in Excel work. On the Insert tab, you’ll see a button called Link in a section called Links. When you click on this option, you’ll open a menu to set a link to any of the available options like another spreadsheet or external website.

Hyperlink Menu excel

After you add your hyperlink, you’ll see it in the spreadsheet and the cell becomes clickable. When you click on it, Excel will send you to the location of the link.

To clear a link, click in the cell, and then find the Editing section on the Home tab on Excel’s ribbon. Click on the Clear dropdown, then choose Remove Hyperlinks.

Clear remove hyperlinks

You might be wondering about the Clear Hyperlinks option on this menu. This option doesn’t remove the link functionality, but it does remove the formatting. That means that the link still takes the user to another spreadsheet or website, but the cell will look normal (and won’t feature an underline or specific text color.)

If you want to remove all hyperlinks in a specific spreadsheet, start by selecting all cells with Ctrl + A on Windows, or Cmd + A on macOS. Then, repeat the same steps. This time, Excel removes all active hyperlinks in your selection. You’ll need to repeat these steps on each sheet to clear all the hyperlinks in your workbook.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Insert multiple sheets ExcelInsert Sheet in Excel
Next Post:Delete Sheets in ExcelDelete sheet right click

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top