How Do I Remove Multiple Hyperlinks in a Spreadsheet in Excel?
Excel is a spreadsheet processing software and is usually distributed as a part of the Microsoft Office suite. Although practical and capable of many functions, Excel does not have an automated feature to remove hyperlinks from multiple cells. There is a quick fix to this problem by tricking the program into thinking that you will turn contents of a cell into a number (instead of the hyperlink text), which will remove the hyperlinks. It’s also possible to remove just the visual effect of the hyperlinks, leaving their functionality untouched. Remove Multiple Hyperlinks Click on an empty cell, type “1” and hit “Enter.” Right-click on the cell and select “Copy.” Press “Ctrl” and then click on each of the cell you want the hyperlink to be removed from. Click on the “Edit” menu and select “Paste Special.” Click on the “Multiply” radio button in the Paste Special window and click on “OK.” All of the hyperlinks should be removed. The text color is returned to the original and the underline go
