Daily posts of Excel tips…and other stuff
Archive for the ‘Hyperlinks’ Category.
Excel provides an easy way to create a table of hyperlinks and even save the workbook as a web page. The built-in method for creating a hyperlink is Insert > Hyperlink (Ctrl+K). The problem with this method is mass changes, like renaming your server. Editing each one (if you have a lot) [...]
This Is Broken has a post about hyperlinks in Excel and specifically about how to delete them. I checked the help files and sure enough the post is accurate. That bit of help truly is broken.
At the end of that post is a link to a product that will remove hyperlinks for you. [...]
The other day I wanted to insert a hyperlink to another spreadsheet.
I hardly ever put Hyperlinks into Spreadsheets - I almost always link to a web page.
This time, however, I wanted to link to a document on the file server.
Insert - Hyperlink - Double click the file - done!
“Wow! that was easy” I thought, then [...]
To get the hyperlink of a cell you can use a simple UDF, like this:
Function RETURNHYPERLINK(Rng As Range) As String
If Rng.Hyperlinks.Count > 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).Address
If Len(RETURNHYPERLINK) = 0 Then
RETURNHYPERLINK = Rng.Hyperlinks(1).SubAddress
End If
End If
End Function
You can then [...]
