LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dan Kowalski
 
Posts: n/a
Default I don't want hyperlinks in my worksheet.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Retrieve data from all of the worksheet within the file dannyboy213 Excel Worksheet Functions 1 March 22nd 06 06:51 PM
Needed: worksheet export help mainemike Excel Discussion (Misc queries) 1 February 24th 06 02:59 AM
How do I remove ALL hyperlinks from a large worksheet? RNewell Excel Discussion (Misc queries) 1 June 30th 05 05:22 PM
Copy from worksheet to another x times Union70 Excel Discussion (Misc queries) 0 March 7th 05 09:03 PM
How to remove all hyperlinks from a worksheet in Excel? Amos Excel Worksheet Functions 4 March 6th 05 11:16 PM


All times are GMT +1. The time now is 12:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"