Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I break a hyperlink in an Excel document?
I have several hyperlinks to graphs within an Excel document, just on
seperate tabs. Now when trying to clear the contents and just type text into that cell, it will not release the hyperlink. It only allows me to delete the entire row or column, which I don't want to do because I would have to re-create the entire document. How can I simply break the hyperlink within the Excel sheet? |
#2
|
|||
|
|||
Sub HyperlinksOut() ActiveSheet.Hyperlinks.Delete End Sub -- Don Guillett SalesAid Software "Fulchp47" wrote in message ... I have several hyperlinks to graphs within an Excel document, just on seperate tabs. Now when trying to clear the contents and just type text into that cell, it will not release the hyperlink. It only allows me to delete the entire row or column, which I don't want to do because I would have to re-create the entire document. How can I simply break the hyperlink within the Excel sheet? |
#3
|
|||
|
|||
You can right-click on the cell and either edit or remove the hyperlink.
"Fulchp47" wrote: I have several hyperlinks to graphs within an Excel document, just on seperate tabs. Now when trying to clear the contents and just type text into that cell, it will not release the hyperlink. It only allows me to delete the entire row or column, which I don't want to do because I would have to re-create the entire document. How can I simply break the hyperlink within the Excel sheet? |
#4
|
|||
|
|||
Select the cell, right click the cell and choose "Remove Hyperlink". If you
have a large range of cells with hyperlinks, on an empty cell type a 1 to give that cell a value of 1. Ctrl+C (copy) the cell and then select the range of hyperlinks. Choose "Paste Special..." from the Edit menu and choose "Multiply" under the Operations section. What's left is just the contents of the range of cells formerly containing the hyperlinks. Good Luck, Ron "Fulchp47" wrote: I have several hyperlinks to graphs within an Excel document, just on seperate tabs. Now when trying to clear the contents and just type text into that cell, it will not release the hyperlink. It only allows me to delete the entire row or column, which I don't want to do because I would have to re-create the entire document. How can I simply break the hyperlink within the Excel sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel hyperlink to another Excel file | Excel Discussion (Misc queries) | |||
How to link a document to a workbook with a hyperlink in excel | Excel Worksheet Functions | |||
Scan and edit document in excel 2003. | Excel Discussion (Misc queries) | |||
How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
Document already opened in excel | Excel Discussion (Misc queries) |