How To Delete A Hyperlinked Logo On My Excel Spreadsheet

Remove Hyperlinks In Excel (Table of Contents)

Remove Hyperlinks in Excel
How to Remove Hyperlinks in Excel?

Introduction to Remove Hyperlinks in Excel

To Remove Hyperlinks in excel, first, select the cell/s from where we need to remove the hyperlinks, then select the Remove Hyperlinks option from the right-click carte list. We tin can as well disable the formation of hyperlinks from the File menu Options from the Proofing tab. In the AutoCorrect option, uncheck the "Internet and Network path with hyperlinks". Once we practise that, we will not become any hyperlinks further after adding any web link or link in the excel worksheet.

How to Remove Hyperlinks in Excel?

This Remove hyperlink is very simple easy to use. Permit united states of america now see how to Remove Hyperlinks in Excel with the assistance of some examples.

You can download this Remove Hyperlinks Excel Template here – Remove Hyperlinks Excel Template

Case #one – Remove hyperlinks by using mouse shortcut

Let's suppose we have given some e-mail ids and URL:

Nosotros will follow the below steps for removing these hyperlinks:

Select the cell or all the cells which contain hyperlinks and Right-click on the cursor. It volition open up a drop-downward listing, as shown in the below screenshot. Click on Remove Hyperlinks.

Information technology volition remove all the hyperlinks in one go.

Example ii – Remove hyperlinks by using Ribbon

We have given some email's and URL.

Select the cells containing hyperlinks or press CTRL+A for selecting the whole worksheet.

Go to the HOME tab and click on the Articulate option under the Editing section. A drop-downward list will open, as shown in the below screenshot.

As we can see, here 2 options are bachelor in the drop-down listing:

Clear Hyperlinks.
Remove Hyperlinks

If we click on "Articulate Hyperlinks", and then a pinkish eraser icon will appear on a screen in the extreme upper left corner, equally shown in the beneath screenshot.

As information technology is clicked on this pink icon, information technology will ask for 2 options:

Clear hyperlinks only.
Clear hyperlinks and formats.

•

Choose the option as per your requirement. Here I selected Clear Hyperlinks and Formats.

By Clicking on Clear Hyperlinks and formats, it removes hyperlinks, every bit shown in the beneath Screenshot.

If we click on "Remove Hyperlinks", as shown in the beneath screenshot, information technology will directly remove all hyperlinks that be on the excel worksheet.

Past Clicking on Remove Hyperlinks, it removes all the links as shown in the below screenshots.

Example #3 – Remove Hyperlinks past Excel setting

Whenever we enter whatsoever URL/ email id in Excel, information technology automatically converts that to hyperlinks due to its pre-existing setting. We tin change this setting by post-obit beneath steps:

Go to the FILE tab and Click on the Options button in the left pane. It volition open up an Excel Options dialog box.

Click on Proofing in the left pane.

It will bear witness you some options on the correct side box. Click on the AutoCorrect Options button.

Information technology will open up a dialog box, as shown in the below screenshot.

Click on ' AutoFormat As You Blazon ' tab. It will show you some options as shown beneath:

Uncheck the option "Internet and network paths with hyperlinks" and click on OK.

Exit from the Excel Options dialog box by clicking on OK.
Now, if you enter any URL or email id in an excel canvas, it won't take it as a hyperlink.

Things to Call up

As in the higher up article, we discussed three options to remove hyperlinks in excel; hence nosotros should recall earlier opting for the option.
Like do we desire to remove the formatting also with hyperlinks or only hyperlinks?
The easiest option is the Mouse shortcut. It saves a lot of time and efforts.