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.
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
4 comments:
Gold! Thanks for the post - saved hours of messing around.
but how to remove butten hyperlink on when we applied on particular cell....help and reply
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
Post a Comment