Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Removing Multiple Hyperlinks (Excel 2003)

    I have a client who has a very large spreadsheet with hyperlinks and he would like to remove the hyperlinks all at one time. Is there a way to do this in Excel? Any help will be appreciated. Thank you in advance.

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

  3. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 15 Times in 15 Posts

    Re: Removing Multiple Hyperlinks (Excel 2003)

    If he would like to turn the hyperlinks into ordinary text values:
    - Activate the Visual Basic Editor (Alt+F11)
    - Activate the Immediate window (Ctrl+G)
    - Type ActiveSheet.Hyperlinks.Delete and press Enter.

    I he wants to clear all the cells containing hyperlinks, he'd need a macro.

  4. #3
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Multiple Hyperlinks (Excel 2003)

    Hi Hans,

    I followed your steps on one of my spreadsheets and it didn't work for me. When I did CTRL + G I couldn't see that anything happened and I typed the text but the hyperlinks were still active. What am I doing wrong?
    Thank you for your help.

    Carol

  5. #4
    2 Star Lounger
    Join Date
    Nov 2005
    Location
    Monkton, Maryland, USA
    Posts
    117
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Removing Multiple Hyperlinks (Excel 2003)

    Hi Hans,

    I spoke too soon. The macro worked very well for me. Thank you again!!
    Carol

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •