Forum Discussion
Gongon
Aug 07, 2020Copper Contributor
How to delete Link to removed documents
Dear everyone, I have a problem: in the Excelsheet I need to work in, there are three links to documents that have been removed or deleted. How can I delete these links? When I follow the normal...
NikolinoDE
Aug 07, 2020Platinum Contributor
If you want to search for and remove hyperlinks in the specific area / cells, have a look at this entry .. is For Excel 2013,2016
https://www.ablebits.com/office-addins-blog/2013/09/20/remove-hyperlinks-from-excel/#remove-multiple-hyperlinks
Most of them are hidden hyperlinks in the conditional formatting of the cells. To delete them, follow the steps below.
Go to the Home tab –> Conditional Formatting –> Manage Rules –> Delete rules in the entire sheet –> OK.
https://www.ablebits.com/office-addins-blog/2013/09/20/remove-hyperlinks-from-excel/#remove-multiple-hyperlinks
Most of them are hidden hyperlinks in the conditional formatting of the cells. To delete them, follow the steps below.
Go to the Home tab –> Conditional Formatting –> Manage Rules –> Delete rules in the entire sheet –> OK.