How to Remove Hyperlinks in Microsoft Excel

Want to remove those clickable links from your Microsoft Excel spreadsheets? If so, it is easy to remove these links or prevent Excel entirely from converting typed text into web links. We’ll show you how to do both.

Related: How to remove underlined hyperlinks in PowerPoint

How to remove a single hyperlink in Excel

To quickly remove a single hyperlink from an Excel spreadsheet, use an option from the right-click menu.

To do this, first, open the spreadsheet with Excel. Find the cell that contains the link you want to remove.

Select a hyperlink.

Right-click on that cell, and from the menu that opens, select “remove hyperlink”.

Choose "remove hyperlink" from the context menu.

Your selected hyperlink is now removed.

Hyperlink removed.

That’s it. You can remove hyperlinks from Word documents in a similar way.

Related: How to remove hyperlinks from Microsoft Word documents

How to remove multiple hyperlinks in Excel

If you want to remove many hyperlinks from an Excel spreadsheet at once, you can use the Excel context menu option again.

To do this, first, open the spreadsheet with Excel.

In the spreadsheet, select the links you want to remove. You can select as many links as you want.

To remove links from the entire worksheet, press Ctrl + A (Windows) or Command + A (Mac) to select the entire worksheet.

Select multiple hyperlinks.

While you have your hyperlinks selected, right-click anywhere on your worksheet and choose “Remove hyperlinks” from the list.

Choose "Remove hyperlinks" From the right-click menu.

And Excel will remove all selected hyperlinks!

The specified hyperlinks have been removed.

You are all set. If you enter a lot of dates in Excel, you may want to learn how to convert text to date values.

How to prevent Excel from turning your links into hyperlinks

By default, when you type a web address into the spreadsheet, Excel automatically converts it into a hyperlink. To prevent this, you can toggle an option in the Excel settings.

To do this, in the upper-left corner of Excel, click “a file”.

click "a file" In the upper left corner of Excel.

From the left sidebar, select More > Options.

Select More > Options from the left sidebar in Excel.” width=”650″ height=”250″ src=”/pagespeed_static/1.JiBnMqyl6S.gif” onload=”pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);” onerror=”this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);”/></p>
<p>A window will open “Excel Options”.  In this window, from the left sidebar, select “Audit”.  Then, on the right, tap “Autocorrect options”.</p>
<p><img loading=

You will see a window “automatic correction”. At the top of this window, click “Auto format as you type”.

click "Auto format as you type" On the "automatic correction" Window.

in the tab “Auto format as you type” , In section “Replace as you type” , turn off the option “Internet and Network Paths With Hyperlinks”. Then click “OK”.

Champions "Internet paths and networks with hyperlinks" and click "OK."

close window “Excel Options” by clicking “OK” At the bottom.

click "OK" On the "Excel Options" Window.

From now on, Excel will not automatically convert your text into hyperlinks. Very useful in many cases!

Similarly, you can disable automatic hyperlinks in Microsoft Word as well.

Related: How to disable automatic hyperlinks in Microsoft Word

Leave a Comment