How to Remove Hyperlinks in Microsoft Excel

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

RELATED: How to Remove Underline Hyperlinks in PowerPoint

How to delete a single hyperlink in Excel

To quickly remove an individual hyperlink from your Excel spreadsheet, use an option on your context menu.

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

Select a hyperlink.

Right-click on this cell and, in the menu that opens, select “Remove hyperlink”.

To select "Remove hyperlink" from the context menu.

And your selected hyperlink is now deleted.

A deleted hyperlink.

That’s it. You can Remove hyperlinks from Word documents in the same way.

RELATED: How to Remove Hyperlinks from Microsoft Word Documents

How to remove multiple hyperlinks in Excel

If you want to remove multiple hyperlinks from your Excel worksheet at once, again you can use the Excel context menu option.

To do this, first open your 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 your entire spreadsheet, press Ctrl+A (Windows) or Command+A (Mac) to select your entire spreadsheet.

Select multiple hyperlinks.

While your hyperlinks are selected, right-click anywhere on your spreadsheet and choose “Remove hyperlinks” in the menu.

To select "Remove hyperlinks" in the context menu.

And Excel will remove all your selected hyperlinks!

Selected hyperlinks removed.

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

How to prevent Excel from turning your links into hyperlinks

By default, when you enter a web address in your spreadsheet, Excel automatically converts it to a hyperlink. To avoid this, you can disable an option in Excel settings.

To do this, in the upper left corner of Excel, click “File”.

Click on "To file" in the upper left corner of Excel.

From the left sidebar, select More > Options.

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

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

Click on "Auto-formatting as you type" on the "Autocorrect" the window.

In the tab “Auto format as you type”, in the section “Replace as you type”, disable the option “Internet and network paths with hyperlinks”. Then click on “okay”.

Disable "Internet and network paths with hyperlinks" and click "OKAY."

Close the window “Excel Options” clicking on “okay” downstairs.

Click on "Okay" on the "Excel Options" the window.

Now, Excel will no longer automatically convert your text to hyperlinks. Very useful in many cases!

Likewise, you can also disable automatic hyperlinks in Microsoft Word.

RELATED: How to Disable Automatic Hyperlinks in Microsoft Word

Comments are closed.