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 |