Removing multiple hyperlinks in Excel

2006 Oct 11
 

Removing a bunch of hyperlinks can be tedious. imagine the time you have to right-click on each of those links and selecting 'remove hyperlink' on the context menu. Of course it would just take two clicks, but what if you are to remove a hundred of them or perhaps 1000 of them? I'm sure that would scrape out the paint of your right-mouse button. :)

I have some simple techniques you can use in order to remove multiple hyperlinks on a page:

Removing just one hyperlink
1. Right-Click on the cell and select Remove Hyperlink on the context menu.

Removing the cell format
1. Select the cells having hyperlinks. You can use CTRL+LEFT CLICK to randomly select a cell.
2. On the menu click on Edit. Hover your mouse to the option Clear and select Fomats. Please note that the cell is still clickable to remove the hyperlink completely you have to select Clear->All.

Remove hyperlink on selected cells the better way
1. Type in any text or number in a blank cell
2. Right-click and select Copy on the context menu.
3. While pressing CTRL, select each hyperlink you wish to be removed
4. On the Edit menu, select Paste Special.
5. Under Operation, click Multiply and then click OK.

Removing using a macro
Assuming you know excel programming you could create a macro to automatically remove the hyperlinks.
1. Start Visual Basic Editor. Alternatively you can press ALT-F11 to start the editor.
2. Double click the workbook you are using on the Project Explorer.
3. Type the following text:


Sub RemoveHyperlinks()
ActiveSheet.Hyperlinks.Delete
End Sub

4. Save your work.
5. Run your macro by pressing ALT-F8 or using the menu by Tools->Macro->Macros
6. Select the macro you have made, it should have the name 'RemoveHyperlinks'.

Related Entries

  • Nov 17 2008Sharing a workbook in Excel for simultaneous edit or collaboration3
  • Oct 15 2008Making your folders private in Windows XP0
  • Jul 30 2008Setting up Virtual Hosts with XAMPP running on Windows XP0
  • Apr 29 2008Formating messages in Basecamp using textile0
  • Mar 15 2008Mass rename files using wscript1
  • Jan 24 2008Remove the pre installed Windows Messenger0
  • Mar 29 2005JPG image default file association fix for Windows XP0

1 Comment

Thanks!! worked great and simple to do.

Leave a comment

Recent Entries

  • Unable to edit entry body in movable type

    Warning: Error in parsing value for property 'display'. Declaration dropped.Warning: Error in parsing value for property 'white-space'. Declaration dropped.Warning: Unknown property 'filter'. Declaration dropped.Warning: Unknown...

  • Old School Favorite: Pacman

    Pacman is one of my personal favorite arcade game. Even today, I can still imagine myself playing some old school games, and i must admit...

  • Earning from your blog with Amazon Associates

    Blogging can be fun, but earning and at the same time having fun is way much better. Here's how to make the most of your...

  • Sending mail via Mercury on localhost using codeigniter and XAMPP

    This is my first time to use Mercury on XAMPP, I never had a mail project before so I guess I'm gonna blog it for...

  • Submitting Sitemaps to Search Engines Google, Yahoo and MSN

    Sitemaps are xml documents used by the search engines to index your website. it is not very crucial for your website but it will help...

Close