Hyperlink Formula in Excel
- 48 Comment
I’m going to add this section to the Microsoft Excel Help section (menu on the left) of the website. An excel user contacted me and questioned how to create a hyperlink inside of excel using the value in another cell to as part of the link. The Formula looks like this:
where link_location is where you want the hyperlink to go to and friendly_name is how the link will appear on your sheet.
For example, if you have a file on your desktop it would look something like this:
Hyperlink(“C:\Documents and Settings\Admin1\Desktop\Example.xls”,”Example Link”)
you would just need to change the exact path to the file on your computer. You can also make the file name a cell reference that contains the name of the file you want to point to, as in this example:
Hyperlink(“C:\Documents and Settings\Admin1\Desktop\” & A1 & “.xls”,A1)
in this example, A1 could equal “Example” and “Example will also be displayed for the hyperlink text.
There is also a way to create this using a macro function, which I will be adding to the macro section in Excel Tips soon.
** Excel Hints provides Excel Tips and Excel Help for All Levels of Experience.