Users who want to add a hyperlink to their Microsoft Excel spreadsheet can do so with relative ease. There are more than one ways to add a hyperlink to a spreadsheet, and we are going to explain how to do it in this post.
How to add Hyperlinks to Excel sheet
If you want to add hyperlinks to your Excel sheet, then you can follow any one of these three methods to achieve the same:
- Type or paste the corresponding URL
- Add hyperlinks using the Link feature
- Use the HYPERLINK Function
Type or paste the corresponding URL to add Hyperlinks to Excel
From our point of view, the easiest way to add hyperlinks to an Excel document is to paste or type the URL into the relevant cell. We suspect this is the option most users will make use of since it is straight to the point and can be done in mere seconds.
- To do it, please copy the URL from the source if required.
- After that, click within the cell where the hyperlink is needed.
- Next, you must paste the link to the cell, then hit the Enter key.
- Alternatively, you can type the URL in its entirety if pasting is not an option.
- Select the Enter key when you’ve completed the task.
Read: How to create a Hyperlink for an existing file in Excel
Add Excel hyperlinks using the Link feature
The other option is to use the Link feature, and chances are you may not have heard of it until today, so let us discuss what this is and how to use it to add hyperlinks to a sheet.
- Select the cell where you want to add the hyperlink.
- Click the Insert tab, then select Link from the Ribbon.
- From the dropdown menu, click on the link if you’ve copied it already to paste it into the cell.
- Or, you could click on Insert Link, then paste or type the URL into the relevant box.
- Tap the Enter key to add it to the chosen cell.
Read: How to easily Find and Remove Hyperlinks in Excel
Use the HYPERLINK Function in Excel
What we have here right now is the final way to add hyperlinks to an Excel sheet. Most people won’t ever consider using the HYPERLINK function, but it is there when needed.
The HYPERLINK function in Excel returns a hyperlink from a given destination and link text. You can use it to create a clickable hyperlink with a formula. Before we can begin here, please note that a formula and syntax are required here for the HYPERLINK function to work correctly.
So, the formula should be HYPERLINK(location, text). The first argument is required at all times and must contain the full path and file name. When it comes down to the second argument, then, you can enter a cell reference or text in quotes to display friendly text data for the hyperlink.
Let us look at an example:
If you want to link cell A1 in Sheet2 from within the workbook you’re currently using, then use the following formula with the display text, The Windows Club:
=HYPERLINK("[https://www.thewindowsclub.com]Sheet2!A1","The Windows Club")
You can make relevant changes where needed to better fit your work. But rest assured, everything works accordingly, so give it a test drive before using it in the real world.
Read: How to modify Hyperlinks in Excel, Word and PowerPoint
Why is my link not clickable in Excel?
To make a link clickable text in Excel, begin by double-clicking the relevant cell, then press the F2 key to go into Edit Mode. Navigate to the end of the URL and promptly press the Space key. Right away Excel will convert a text string into a clickable hyperlink.
Leave a Reply