RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet

Subject: RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet
From: "Garrett R. Winn" <garrett1 -at- garrettwinn -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Tue, 23 Sep 2008 12:12:07 -0600

I like to use a program called Pure Text
(http://www.stevemiller.net/puretext/).

I can just select all the cells in the table that I want, do a cut, then
paste over the top using the shortcut key combo I created, and voila, I have
no hyperlinks.

This is a little quicker (once you have the program installed) than Dan's
method.

Plus, I use Pure Text all the time when I copy and paste - to remove all the
formatting junk that usually accompanies the operation.

Much success,

Garrett

-----Original Message-----
From: techwr-l-bounces+garrett1=garrettwinn -dot- com -at- lists -dot- techwr-l -dot- com
[mailto:techwr-l-bounces+garrett1=garrettwinn -dot- com -at- lists -dot- techwr-l -dot- com] On
Behalf Of Hemstreet, Deborah
Sent: Tuesday, September 23, 2008 10:46 AM
To: techwr-l -at- lists -dot- techwr-l -dot- com
Subject: Is there a way to delete ALL hyperlinks in an Excel spreadsheet

Hi all,



Would anyone know if there is a way to delete all hyperlinks in a
spreadsheet, for over 100 cells?



Thanks in advance,



Deborah

One Person DOES Make a Difference

http://www.tech-challenged.com <http://www.tech-challenged.com/> (under
construction)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ComponentOne Doc-To-Help gives you everything you need to author and publish
quality Help, Web, and print content. Perfect for technical authors,
developers, and policy writers. Download a FREE trial.
http://www.componentone.com/DocToHelp/

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as garrett1 -at- garrettwinn -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit
http://lists.techwr-l.com/mailman/options/techwr-l/garrett1%40garrettwinn.co
m


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

ComponentOne Doc-To-Help gives you everything you need to author and
publish quality Help, Web, and print content. Perfect for technical
authors, developers, and policy writers. Download a FREE trial.
http://www.componentone.com/DocToHelp/

True single source, conditional content, PDF export, modular help.
Help & Manual is the most powerful authoring tool for technical
documentation. Boost your productivity! http://www.helpandmanual.com

---
You are currently subscribed to TECHWR-L as archive -at- web -dot- techwr-l -dot- com -dot-

To unsubscribe send a blank email to
techwr-l-unsubscribe -at- lists -dot- techwr-l -dot- com
or visit http://lists.techwr-l.com/mailman/options/techwr-l/archive%40web.techwr-l.com


To subscribe, send a blank email to techwr-l-join -at- lists -dot- techwr-l -dot- com

Send administrative questions to admin -at- techwr-l -dot- com -dot- Visit
http://www.techwr-l.com/ for more resources and info.


Follow-Ups:

References:
Is there a way to delete ALL hyperlinks in an Excel spreadsheet: From: Hemstreet, Deborah

Previous by Author: RE: Ten Technical Writing Stereotypes
Next by Author: Re: Using FrameMaker for More Than Tech Writing
Previous by Thread: Re: Using FrameMaker for More Than Tech Writing
Next by Thread: RE: Is there a way to delete ALL hyperlinks in an Excel spreadsheet


What this post helpful? Share it with friends and colleagues:


Sponsored Ads