Remove hyperlinks from range of cells in Excel
For example, I copied and pasted a Table from a web page. By default, it has lot of hyperlinks - how can I remove them all in one shot.
To do it in Excel, here is the answer:
a) Select the entire range. Since it is possible that clicking on a cell with Hyperlink will redirect to the web page, an area outside of the range can be selected as shown below. This range would be easier to select.
b) Under "Home", click on "Clear" under "Editing" section. Click on "Clear Hyperlinks" as shown below. All Hyperlinks are removed.