• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

How to remove multiple hyperlinks in Excel?

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?
0
Missus Miss_Sellaneus
Asked:
Missus Miss_Sellaneus
  • 2
  • 2
1 Solution
 
genie3kCommented:
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
1.jpg
0
 
genie3kCommented:
click excel options then play with options given here
2.jpg
0
 
Missus Miss_SellaneusAuthor Commented:
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.
0
 
Missus Miss_SellaneusAuthor Commented:
Wow, clear all formats isn't working now. It removed the color & font formatting, but left the hyperlinks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now