Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I copied a table from a web page. Many of cells contain hyperlinks. In Excel,
they are not useful; an accidental click sends my window off to the web. I can right click on them and disable the hyperlink, but there are over a hundred of them. If I select more than one of them, I do not have the option of removing the hyperlinks. I need a way to get rid of all the hyperlinks quickly and easily. Is there a button hidden somewhere, or is MicroSoft opposed to anything that stops unintended connections to the internet? (I think I finally managed to get Word to stop turning anything with a dot in it into a link.) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Retrieve data from all of the worksheet within the file | Excel Worksheet Functions | |||
Needed: worksheet export help | Excel Discussion (Misc queries) | |||
How do I remove ALL hyperlinks from a large worksheet? | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
How to remove all hyperlinks from a worksheet in Excel? | Excel Worksheet Functions |