Microsoft Excel trick : Remove all hyperlinks at the same time
How to remove all links from a Microsoft Excel spreadsheet in 2 seconds?
(Works for both Mac and Windows)
“Playing ‘Whack-a-Mole’ with Excel links? When you aim for cells but hit URLs and your browser’s the surprise guest—time to give those links the boot!”
Select all cells that contain hyperlinks, or press Ctrl+A (or Command+A on Mac) to select all cells.
Right-click, and then click Remove Hyperlinks.
Done, enjoy 🙂
This tip works on : Excel for Microsoft 365 Word for Microsoft 365 Outlook for Microsoft 365 PowerPoint for Microsoft 365 Excel 2021 Word 2021 Outlook 2021 PowerPoint 2021 Excel 2019 Word 2019 Outlook 2019 PowerPoint 2019 Excel 2016 Word 2016 Outlook 2016 PowerPoint 2016 Excel 2013 Word 2013 Outlook 2013 PowerPoint 2013
From : Microsoft support site (Remove or turn off hyperlinks)