Wednesday, January 21, 2009

Remove Hyperlink from multiple cells in Excel

In a blank cell, enter the number 1 .
Copy that cell.
Select the cells with the hyperlinks.
Right click on the seleted cells and click Paste Special.
Under operations, select multiply and click OK.

4 comments:

benm said...

Gold! Thanks for the post - saved hours of messing around.

Sudhir Sakore said...
This comment has been removed by the author.
Sudhir Sakore said...

but how to remove butten hyperlink on when we applied on particular cell....help and reply

Sudhir Sakore said...

one more problem is that if we apply hyperlink ...save and closed the excel file in libreoffice. when we open that file the applied hyperlink has deactived & getting error "Invalid rang" what is solution...help and reply