How to Remove URL hyperlink from multiple cells or columns in Excel - MS Office Views : 295
Tagged in : MS Office
0 0
Send mail
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.



By sithurajkumar, On - 2011-10-18



    Login to add Comments .