How to Remove URL hyperlink from multiple cells or columns in Excel
by sithurajkumar[ Edit ] 2011-10-18 17:24:20
How to Remove URL hyperlink from multiple cells or columns in Excel
It's very simple. In a blank cell, enter the number 1. Copy that cell. Select the cells with the hyperlinks (you may need to click the first cell, hold down the shift key, and press the arrow keys to select multiple cells). Once the cells are selected, right click on them and select Paste Special. Under operations, select multiply and click OK.
