Hyperlinks in Excel 2007

  • Thread starter Thread starter Wiley 1
  • Start date Start date
W

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?
 
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
 
Back
Top