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

How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...
How to hide page breaks in worksheets in Microsoft Excel ?
When the page breaks is used to adjust the print area in a worksheet in excel , this would show up a...
How to protect all worksheets at once in Excel using VBA ?
Assume that you have a worksheet and you wish to protect all of the worksheets with a password at on...