How to remove multiple hyperlinks in Excel?

Posted on 2009-12-23
Last Modified: 2012-05-08
I have a spreadsheet in Excel 2003 that I created by pasting from a web site.  There's a column of hyperlinks. I want to remove all the hyperlinks but want the text to remain. I can do this one cell at a time by right-clicking on a cell and selecting 'Remove Hyperlink'.  But if I select more than one cell at a time, I don't have the 'Remove Hyperlink' option. Is there any easier way to replace all of these hyperlinks with text only?

Please note: I have already solved this myself by copying the column into notepad and then pasting it back into Excel. But this eliminates all other formatting. Is there a non-macro way to do this using only Excel so that I can save the formatting?
Question by:Missus Miss_Sellaneus
    LVL 2

    Accepted Solution

    Removing hyperlinks using 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

    in office 2007 You can prevent Excel from formatting URLs and network links by removing its AutoFormat function at the AutoCorrect dialog box. I am using Office 2007
    LVL 2

    Expert Comment

    click excel options then play with options given here
    LVL 13

    Author Comment

    by:Missus Miss_Sellaneus
    The change in autocorrect options didn't solve the problem. If I paste from a site, links are still hyperlinks in the worksheet.

    Clear all formats removes all formatting. I wanted to save the text & color formatting. But it apparently is the best solution. Thanks.
    LVL 13

    Author Comment

    by:Missus Miss_Sellaneus
    Wow, clear all formats isn't working now. It removed the color & font formatting, but left the hyperlinks.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now