In this article we will show you how to hyperlink in google sheets using insert link, the HYPERLINK formula and the right click method. Simply follow the steps below:
In our example we have clicked cell A1 as this is where we would like to add a hyperlink
In our example we would like our display text to be “Lido Website”.
This step will require you to input a valid website URL to create your hyperlink. In our case we would like to use the URL https://www.lido.app/.
If you have an existing link, you can simply copy the link from the URL bar in your web browser and paste it like so:
You can also type your link in the URL box and Google Sheets will give you URL suggestions from the internet to choose from as you type.
Now you will have a cell containing a clickable hyperlink with the text you specified.
In our example we will select cell A1 as this is where we would like to add a hyperlink.
Here we will be using the HYPERLINK formula in the form of =HYPERLINK(“link”,”text”)
Formula Breakdown:
Link: This is where you input your URL
Text: Text is your display label for the hyperlink. This is what appears inside the cell.
Remember to enclose each of these in quotation marks (“”) as your inputs are not cell references. Forgetting to put quotation marks will result in #ERROR! Or #NAME? prompts.
For this example we will put =hyperlink("https://www.lido.app/","Lido")
You now have a hyperlink that uses your desired URL and anchor text (display text). Click on the hyperlink to view a preview of the link. Clicking on the preview will take you to the website.
Let’s still use “Lido” for our display text and “https://www.lido.app/” for the URL.
Now you have your hyperlink available on your sheet.
There might be instances where you want to create a hyperlink in your spreadsheet to quickly navigate in between the sheets of your workbook. Follow this simple guide to be able to learn how to make a hyperlink to another sheet in Google Sheets.
Let's make a hyperlink of the Cash Flow Sheet for this example. Simply click on the sheet name in the list.
This can help in navigating larger sheets or related sheets as you no longer have to scroll along the list of visible sheets in your workbook.
In conclusion, those are the different ways to add a hyperlink to a cell in Google Sheets.
We hope this article has helped you and given you a better understanding of how to create a Google Sheets hyperlink. You might also like our articles on how to convert a PDF to Google Sheets and how to wrap text in Google Sheets.
To optimize your workflow, we recommend reading our guide on how to attach a Google Sheet to an email.
-How to Use People Chips in Google Sheets
-How to Strikethrough in Google Sheets
-How to Remove Gridlines in Google Sheets
-How to Underline in Google Sheets
-How to Add Bullet Points in Google Sheets
-How to Indent in Google Sheets
-Add Line Break in Google Sheets
-Color Every Other Row in Google Sheets
