JE McGimpsey

Posts: n/a

Removing hyperlinks in bulk

See

http://www.mcgimpsey.com/excel/nohyperlinks.html

In article ,
Terry Pinnell wrote:

A worksheet I prepared contains a lot of hyperlinks. (I pasted some
cells in from a web site.) I can see how to remove each one
individually with R-click Hyperlink Remove Hyperlink. But so far
haven't found a way to do it for an entire column, or the whole sheet.

Working with the sheet is awkward, as I often inadvertently open a
link in my browser when all I want to do is copy the text in that
cell.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Removing hyperlinks in bulk	Elkar	Excel Discussion (Misc queries)	1	October 26th 05 11:20 AM
Problem removing hyperlinks in workbook	Tai-Pan	Excel Discussion (Misc queries)	5	October 21st 05 11:32 PM
Removing Hyperlinks	Sloth	Excel Discussion (Misc queries)	2	October 5th 05 08:54 PM
removing hyperlinks	Laura	Excel Discussion (Misc queries)	1	June 9th 05 08:16 PM
removing hyperlinks	Gary's Student	Excel Discussion (Misc queries)	0	June 9th 05 07:29 PM

All times are GMT +1. The time now is 11:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us