Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.ģ. Activate the worksheet that you want to remove the hyperlinks from.Ģ. If you are a skilled and professional user, you can create macros to remove the hyperlinks from an active worksheet.ġ. Remove all hyperlinks in a worksheet with VBA code If you have to remove hyperlinks in different worksheets, repeat the operations again and again. This method is not available for Excel 2007 and earlier versions. And all the hyperlinks in the selected range are deleted at once. Tips: You can also right-click the selected range, and choose Remove Hyperlinks from the menu, see screenshot:ģ. Then click Home > Clear > Remove Hyperlinks, see screenshot: Select the range containing hyperlinks you want to remove.Ģ. If the hyperlinks are in the same worksheet, you can use the Remove Hyperlinks function to remove them.ġ. Remove all hyperlinks in a range with Remove Hyperlinks command
Remove all hyperlinks in a range with Remove Hyperlinks command (Excel 2010 and later versions).
Remove hyperlink in word 365 how to#
How to quickly deal with the unwanted hyperlinks in Excel? If you want to remove hundreds of hyperlinks which exist in a worksheet or the whole workbook, or turn off the hyperlinks directly when creating them. How To Remove or turn off Hyperlinks In Excel?
0 kommentar(er)
