In this tutorial, you will learn how to hyperlink in Google Sheets.
One of the most powerful features of web-based tools such as Google Sheets is the ability to insert hyperlinks into a spreadsheet and follow them, all without leaving the browser. Whether you want to link to another location on the internet, or another cell in the same spreadsheet, Google Sheets makes it quick and easy to add hyperlinks to your spreadsheet.
If you simply want to add a hyperlink and don’t mind having the hyperlink URL displayed in the text, the auto hyperlinking option is the quickest option
Here’s how to use it:
Click on a cell and start typing the URL you want to link to
Hit enter and the URL will format as link, with blue color and underline
To follow the link, hover over the URL, then click on the link in the popup that appears. The linked URL will load in a new tab of your browser
You can also add other text to the cell in addition to the URL and the hyperlink will still work
If you want to change the text displayed for a hyperlink, add a hyperlink to your spreadsheet as described above, then follow these steps
Hover over the hyperlink you want to edit, then click on the Edit pencil icon in the popup
Update the text in the Text field, then click Apply
The URL portion of the cell text will update
Hyperlink to a Sheet, Range or Cell
In addition to linking to external URLs, you can also link to regions of the current spreadsheet
Click on the cell in which you want to add the hyperlink and open the Insert menu, then choose Link
In the Text field, type in the text you want to display for the link
In the next field, type in the A1 reference for the cell or range you want to link to. For example, Sheet2!C4 to reference cell C4 on the sheet called Sheet2
You can also search for a sheet or named range by name using the second text field, or click on Select a Range of cells to link to select the linked cell(s) with your mouse
When you’re done editing the link, click Apply and the link will appear in the cell. Links to other regions of the spreadsheet are formatted the same as links to external sites, and can be followed in the same way
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to hyperlink in Google Sheets. Want more? Check out all the Google Sheets Tutorials.