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: "Dan Goldstein" <DGoldstein -at- riverainmedical -dot- com>
To: <techwr-l -at- lists -dot- techwr-l -dot- com>
Date: Tue, 23 Sep 2008 12:58:03 -0400

One way is to cut and paste into a Word table, remove the hyperlinks en
masse (CTRL+SHIFT+F9), and then paste back into the Excel spreadsheet.

> -----Original Message-----
> From: Hemstreet, Deborah
> Sent: Tuesday, September 23, 2008 12:46 PM
> To: techwr-l -at- lists -dot- techwr-l -dot- com
> Subject: Is there a way to delete ALL hyperlinks in an Excel
> spreadsheet
>
> Would anyone know if there is a way to delete all
> hyperlinks in a spreadsheet, for over 100 cells?
>

This message contains confidential information intended only for the use of the addressee(s). If you are not the addressee, or the person responsible for delivering it to the addressee, you are hereby notified that reading, disseminating, distributing, copying, electronic storing or the taking of any action in reliance on the contents of this message is strictly prohibited. If you have received this message by mistake, please notify us, by replying to the sender, and delete the original message immediately thereafter. Thank you.

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

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: What format do you use for proofing?
Next by Author: FW: Is there a way to delete ALL hyperlinks in an Excel spreadsheet
Previous by Thread: Is there a way to delete ALL hyperlinks in an Excel spreadsheet
Next by Thread: Using FrameMaker for More Than Tech Writing


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


Sponsored Ads