![]() However, the Remove Hyperlinks tool does not work across multiple worksheets. To remove more than one hyperlink, select a range containing multiple hyperlinks, such as a range of cells, columns, rows, or an entire worksheet, then right-click on any cell, and select Remove Hyperlinks from the pop-up menu. Is there an easier way to remove these hyperlinks? Answer: If you just get a few hyperlink to remove Excel 2010 provides a new option called Remove Hyperlinks that enables you to remove multiple hyperlinks. My current approach is to right-click on each cell and select Remove Hyperlink one at a time. To avoid triggering a hyperlink, I click on a nearby cell and then arrow over to the cell containing the hyperlink. My problem is the pasted data often contains hundreds of hyperlinks, which makes it difficult to then select those cells without triggering the hyperlinks. ![]() How to Remove hyperlinks in Excel Question: Is there an easier way to remove these hyperlinks? I frequently copy and paste large amounts of data from the web.
0 Comments
Leave a Reply. |