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

["Hemstreet, Deborah" <DHemstreet -at- kaydon -dot- com>]

I received a couple of excellent suggestions - this one, however, was
the quickest - and it worked!

Thanks Rebecca!

Deborah 
-----Original Message-----
From: rdowney -at- matrox -dot- com [mailto:rdowney -at- matrox -dot- com] 
Subject: RE: Is there a way to delete ALL hyperlinks in an Excel
spreadsheet

Hi.

The following is in the Microsoft Excel Help (and it works)

Deactivate several hyperlinks at once

1. Type the number 1 in a blank cell, and right-click the cell. 

2. Click Copy on the shortcut menu. 

3. While pressing CTRL, select each hyperlink (hyperlink: Colored and
underlined text or a graphic that you click to go to a file, a location
in a
file, a Web page on the World Wide Web, or a Web page on an intranet.
Hyperlinks can also go to newsgroups and to Gopher, Telnet, and FTP
sites.)
you want to deactivate. 

How? (
To select a cell that has a hyperlink (hyperlink: Colored and underlined
text or a graphic that you click to go to a file, a location in a file,
a
Web page on the World Wide Web, or a Web page on an intranet. Hyperlinks
can
also go to newsgroups and to Gopher, Telnet, and FTP sites.) in it
without
jumping to the hyperlink destination, click the cell and hold the mouse
button until the cursor becomes a cross , then release the mouse button.

)

4. Click Paste Special on the Edit menu. 

5. Under Operation, click Multiply and then click OK. 

I tried it, it seemed to work on my sample page.
Hope it helps.

-=-=-=-=-=-=-=-=--=-=-=-=-=-=-=-=-=-=-
Rebecca Downey  -- rdowney -at- matrox -dot- com
Matrox Imaging  -- Technical Writer  



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

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.