Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in Excel 2007
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? -- Wileyone |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hyperlinks in Excel 2007
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 "Wiley 1" wrote in message ... 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? -- Wileyone |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
deleting lots of hyperlinks in Excel 2007 | Excel Discussion (Misc queries) | |||
Why do hyperlinks in excel 2007 point to the wrong place after so. | Excel Discussion (Misc queries) | |||
Excel 2007 & Hyperlinks | Excel Discussion (Misc queries) | |||
Excel 2007 Crashed - All Hyperlinks broken | Excel Discussion (Misc queries) | |||
Hyperlinks Not Instant In 2007 ?? | New Users to Excel |