How to clear Hyperlinks from Spreadsheet in Microsoft Excel 2013?

The Microsoft Excel includes a cool feature that lets the users to quickly remove all the hyperlinks from the excel workbook.

One of the typical scenario when you want to use this kind of feature is when you try to copy the data from the external source and which includes and hyperlink to the website. When the number of hyperlinks increases , it becomes difficult to manually remove the link one by one . Using the clear hyperlink will save you lot of time in this case.

How to clear Hyperlinks from Spreadsheet in Microsoft Excel 2013?

To Clear the hyperlink, select the worksheet and then navigate to Home tab and then in the Editing Group -> Clear DropDownList, Click Clear Hyperlinks.

How to clear Hyperlinks from Spreadsheet in Microsoft Excel 2013?

You can remove the hyperlinks by clearing the formatting by clicking the “Clear Button Options” and the “Clear Hyperlinks and Formats”.

How to clear Hyperlinks from Spreadsheet in Microsoft Excel 2013?

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


x

Interesting BlogPosts to read

Event on Building intelligent bots with the Microsoft Bot Framework in Manchester
Want to learn about building intelligent bots using Microsoft's Bot Framework. Here's an interesting...
How to find the Created and Last Modified time in Microsoft Excel ?
You can easily find out the exact date and time when the excel workbook was created and modified usi...
How to copy multiple sheets in Excel?
There are scenarios where you might want to make a copy of multiple worksheets in a workbook in Micr...