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)