How Do You Make a Link Clickable in Google Sheets?

You can make a link clickable in Google Sheets by using the HYPERLINK function.

How to Use the HYPERLINK Function

1. Select the cell where you want to display the clickable link.
2. Type the following formula: =HYPERLINK(URL, Link Text)
   • URL: Replace this with the actual web address you want to link to.
   • Link Text: Replace this with the text you want to display as the link.
3. Press Enter to complete the formula.

Examples

• Example 1: To create a link to Google's homepage, you would use the formula =HYPERLINK("https://www.google.com", "Google Homepage"). This will display "Google Homepage" as the link, and clicking on it will take you to Google's website.
• Example 2: If you want to link to a specific cell within the same spreadsheet, you can use the cell reference as the URL. For instance, =HYPERLINK("#Sheet1!A1", "Go to Cell A1") will create a link that takes you to cell A1 on Sheet1.

Additional Tips

• You can use the " " (quotation marks) around the URL and link text to include spaces or special characters.
• You can format the link text using the Font and Alignment options in the toolbar.
• You can also use the Insert > Link option from the Google Sheets menu to create a clickable link.