Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change text copied to excel from webite to not link bac.
When I copied text from a website and pasted into excel, everything links
back to the website. For example if I click into the cell of the text in excel the webpage from where it originated from comes up. I could not see anything in formatting. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change text copied to excel from webite to not link bac.
Activate the cell that contains the hyperlink, right-click, and then select -Hyperlink, Remove Hyperlink.- you can only use this when you have selected a single cell. To deactivate all hyperlinks, you have to use a macro. To create the macro, press -Alt-F11- to activate the Visual Basic Editor, select -Insert, Module- and then paste this code: Code: -------------------- Sub DelLinks() Cells.Hyperlinks.DeleteEnd Sub -------------------- all hyperlinks on the active sheet become normal text. sherryp;184588 Wrote: When I copied text from a website and pasted into excel, everything links back to the website. For example if I click into the cell of the text in excel the webpage from where it originated from comes up. I could not see anything in formatting. Please help. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51000 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I change text copied to excel from webite to not linkbac.
Instead of using <paste, you could use Edit | Paste Special | Values
(check) | OK. Alternatively, once you have pasted (and the pasted cells are still highlighted), press Alt-F11 to bring up the VBE, then CTRL-G to enter the immediate window, and type this: selection.hyperlinks.delete then press <enter. Hope this helps. Pete On Jan 16, 12:34*am, sherryp wrote: When I copied text from a website and pasted into excel, everything links back to the website. For example if I click into the cell of the text in excel the webpage from where it originated from comes up. I could not see anything in formatting. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
when i copied text to excel 2007, how do i convert it to number | Excel Discussion (Misc queries) | |||
copied formulas on Excel the value doesn't change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
Excel file change to 'read-only' when copied to another server | Excel Discussion (Misc queries) | |||
how do I convert copied Text numbers into values in Excel? | Excel Worksheet Functions |