How to Remove URL hyperlink from multiple cells or columns in Excel

by sithurajkumar 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.



Tagged in:

1071
like
1
dislike
0
mail
flag

You must LOGIN to add comments