By Clicking on Clear Hyperlinks and formats, it removes hyperlinks, as shown in the below Screenshot.

Here I selected Clear Hyperlinks and Formats.

Choose the option as per your requirement.

As it is clicked on this pink icon, it will ask for two options:.

If we click on “Clear Hyperlinks”, then a pink eraser icon will appear on a screen in the extreme upper left corner, as shown in the below screenshot.

As we can see, here two options are available in the drop-down list:.

A drop-down list will open, as shown in the below screenshot.

Go to the HOME tab and click on the Clear option under the Editing section.

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

It will remove all the hyperlinks in one go.Įxample 2 – Remove hyperlinks by using Ribbon.

It will open a drop-down list, as shown in the below screenshot.

Select the cell or all the cells which contain hyperlinks and Right-click on the cursor.

We will follow the below steps for removing these hyperlinks:

Let’s suppose we have given some email ids and URL: Worse case scenario, none of those things happen but these keyboard shortcuts have exercised your brain so it functions better in retirement and you stave off that cognitive decline.You can download this Remove Hyperlinks Excel Template here – Remove Hyperlinks Excel Template Example #1 – Remove hyperlinks by using mouse shortcut You may well need to make spreadsheets for that too but you’ll be so quick that most of your time will be spent under water. You can now retire early and setup a scuba diving business. A bit of extra cash to get that boat you always wanted. You’ll be push towards the front of the partnership queue. Your boss breathing over your shoulder will take note of your effectiveness. Imagine how useful you’d be at work (or home) if you could double your spreadsheet speed.

It’s so underrated that I’ve never heard it mentioned. What other computer application could be more useful? Learning Excel shortcut keys is probably one of the most underrated ways of getting a financial leg up ever. It can’t be blamed with the amount of money moving around it. 20 more years of experience.Īcross the whole of the lucrative finance industry Excel is used. It may not be as sexy as Numbers but it makes up for that in experience. The term ‘excel file’ is brandished around more often than the term ‘spreadsheet’. It’s arguably defined modern accounting and has arguably become a noun. Excel was initially released last century in 1987.

Excel shortcut remove hyperlink mac