Question

Locked

How can I erase hyperlinks in Excel 2000/2003?

By carlos.nino ·
Hi,

I have an Excel document with more than 15000 emails in it, and I need to get rid of the hyperlinks so only plain txt is left. I know I can get rid of them one by one by clicking on it and choosing rase Hyperlink from the popup menu, but:
Is there a way to erase them all?

Thanx in advance!

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

copy and "paste special - values"

by ante_river In reply to How can I erase hyperlink ...

Select entire worksheet, copy and paste special "values" to empty worksheet. (You will lose any formatting, but will rid yourself of hyperlinks).

Or, if you don't want to copy & paste, try this...

1. Type the number 1 in a blank cell, and right-click the cell.
2. Click Copy on the shortcut menu.
While pressing CTRL, select each hyperlink
3. Click Paste Special on the Edit menu.
4. Under Operation, click Multiply and then click OK.

Collapse -

Thanks a lot

by carlos.nino In reply to copy and "paste special - ...

Simple and effective.

Again, thaks a lot! :^)

Collapse -

a possible solution to losing all formatting

by marj In reply to copy and "paste special - ...

If you don't want to lose all of your sheet's formatting, another idea that will work if your hyperlinks are in just certain columns is to just copy & paste special "values" of that column to a blank column - then you can cut & paste it back to the original column

Collapse -

quick vba solution

by smith In reply to How can I erase hyperlink ...

You can use the following vba to create a macro that will strip out the hyperlinks.
Save it with the workbook or worksheet and then return to sheet you want to clear and run the macro.

I don't remember where I originally found it but google "remove hyperlinks excel" should bring up several references to this code.

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

Collapse -

Prevent Hyperlinks in Excel

by mahansench In reply to How can I erase hyperlink ...

Hi, To prevent Hyperlinks in Excel, do the following:
On the Tools menu, click Autocorrect Options.
On the Autoformat As You Type tab, click to clear the Internet and network paths with hyperlinks check box.
Click OK.
You can also gain access to the Autocorrect Options feature by typing a hyperlink, and then clicking Stop Automatically Creating Hyperlinks on the smart tag button that appears.

That's all.

Collapse -

Erase Hyperlinks with ASAP Utilities

by stefana In reply to How can I erase hyperlink ...

Try ASAP Utilities! It is a gem with an Excel installation, and has a great number of excellant solutions.

Back to Software Forum
7 total posts (Page 1 of 1)  

Software Forums