Hyperlinks in Excel 2007

[Wiley 1]

I copied data from a website to an Excel 2007 worksheet. Now each data
element has a hyperlink back to the original website. How do I remove all
these hyperlinks?

 

[Ashish Mathur]

Hi,

This procedure will remove the hyperlinks but let the text remain

1. Type 1 in any cell, say C15;
2. Now copy C15;
3. Highlight the range of hyperlinks;
4. Now do Alt+E+S and select multiply.

This will remove the hyperlinks.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com