Hyperlinks in Excel

There's a hyperlink function in Excel that allows you to specify the link location as well as the text that displays for you to click. Here's how to set it up:


The first section is where you put the address for your hyperlink. The second part, after the comma, is where you put in what text will display. For example:

=HYPERLINK("http://www.stacydubois.com","Stacy's Notes")
will look like this: Stacy's Notes

You can also use it for linking to files on your computer. For example:


The "friendly_name" can also be a reference to another cell.


Post a Comment