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:
=HYPERLINK(link_location,friendly_name)
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:
=HYPERLINK("C:\Users\Stacy\Documents","Documents")
The "friendly_name" can also be a reference to another cell.
=HYPERLINK(link_location,friendly_name)
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:
=HYPERLINK("C:\Users\Stacy\Documents","Documents")
The "friendly_name" can also be a reference to another cell.
Posts
0 comments:
Post a Comment