Google Answers Logo
View Question
 
Q: Delete "all" hyperlinks in an excel spreadsheet ( Answered 5 out of 5 stars,   0 Comments )
Question  
Subject: Delete "all" hyperlinks in an excel spreadsheet
Category: Computers
Asked by: pcogs-ga
List Price: $2.50
Posted: 14 May 2003 05:25 PDT
Expires: 13 Jun 2003 05:25 PDT
Question ID: 203548
How can I remove all of the hyperlinks in an excel spreadsheet at one
time? The sheet I am working on has far too many to individually right
click on each one and delete them.
Answer  
Subject: Re: Delete "all" hyperlinks in an excel spreadsheet
Answered By: tehuti-ga on 14 May 2003 06:01 PDT
Rated:5 out of 5 stars
 
Hello pcogs,

How you do it depends on which version of Excel you are using. 

1. Excel 2002

All you have to do is select all the cells and right click.
Select “Hyperlink” from the pop-up menu and then click on the “Remove”
button.

If you want to avoid Excel 2002 automatically generating hyperlinks in
future, go into the Autocorrect dialog box and disable automatic
hyperlinks.

2. Excel 2000

The method described above does not work in Excel 2000. You need to
create a macro instead.

To create the macro, press Alt-F11 to activate the Visual Basic
Editor, select Insert, Module to insert a new VBA module into your
project, and then enter macro code. Here is code from “The Spreadsheet
Page” site for a macro called “ZapHyperlinks”

Sub ZapHyperlinks()
   Cells.Hyperlinks.Delete
End Sub  

Should you ever want to retain hyperlinks in some of your cells, you
can also specify a range over which you want the macro to work. Here
is an example from MrExcel.com of a macro called “RemoveHyperLinks”:

Sub RemoveHyperLinks()
Range("A2:A999").Hyperlinks.Delete
End Sub

If you are not sure how to create a macro, you can find a walkthrough,
illustrated with screenshots, at
http://www.mrexcel.com/tip038.shtml 

You cannot disable the automatic hyperlinks feature on Excel 2000, but
you can override it each time a hyperlink is created: “If Excel
creates a hyperlink from your cell entry, click the Undo button (or
press Ctrl-Z) to restore the cell's contents to normal text. Or, you
can precede the cell entry with an apostrophe.” (From The Spreadsheet
Page, Excel User Tips)

Sources:

MrExcel Consulting 
http://www.mrexcel.com/td0107.html
http://www.mrexcel.com/tip038.shtml

and Excel User Tips at The Spreadsheet Page
http://www.j-walk.com/ss/excel/usertips/tip031.htm 

Google search strategy: remove hyperlinks Excel
pcogs-ga rated this answer:5 out of 5 stars
The answer was right and was much more thorough than expected. 
This was the first time I have tried the service and it was great!

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy