Today we will be teaching you a more unique type of formula, one which can be very useful in certain situations. We will teach you specifically, how to create a hyperlink within a spreadsheet. This way, you can create links (with whatever label you want), that once you click on them, will bring you to a completely different website.Â
This skill may not be useful in basic spreadsheets, but there are certain scenarios when this could be useful. For example, you may be making a spreadsheet for your company, and would like to bring you to someone else’s website. You could do that by using the hyperlink formula.
If you are still a beginner, however, we recommend learning these 10 formulas first, before moving onto hyperlinks.
The Hyperlink Formula
Here is how the formula looks:
=HYPERLINK(URL, Link Label)
How this formula works is quite simple. The URL is just the link of the website, and the link label is how you want the link labeled. Often times, I am sure you do not want a long ugly link to be in your way. That is why you can use a link label instead.
How to use it
Letâ€™s say we have this spreadsheet, where we want to make a link for a â€œvery cool website.â€
How would we go about this? Let me show you:
Step 1: Get a link from a â€œvery cool website.â€ We of course chose the coolest website we know, â€œwww.sheetpointers.comâ€
Step 2: Start the Hyperlink formula
Step 3: Enter your link, remembering to surround it with quotation marks
Step 4: Enter your link label, again remembering to use quotation marks
Step 5: Click enter, finishing out the formula
Step 6: Click on your link, making sure it takes you to a very cool website
As you can see, not only did it take you to a cool website…it took you to the coolest website that ever existed. (Thank you thank you)
We hoped you enjoyed todayâ€™s lesson, with our slightly comedic tone. In the end, adding hyperlinks is extremely easy, but can impress your bosses or coworkers. Maybe you need to have an easy to access link for more information, or need to link a registration form. Whatever it is, the hyperlink formula has you covered. Lastly, as always, happy spreadsheeting! 🙂
If you want to read more things about hyperlinks, please visit these websites.