The steps in this guide are going to show you how to add a link to a cell in a Google Sheets spreadsheet so that someone can click that link and open a Web page. After our brief listing of the steps below we will continue with additional information and pictures of the steps.
- Open a file in Google Sheets.
- Select the cell where you want to add the link.
- Click the Insert link icon in the toolbar above the spreadsheet.
- Enter the URL of the Web page for the link, then click Apply.
Adding links to a spreadsheet gives you the ability to offer your spreadsheet readers and collaborators additional resources in the form of external Web pages.
This is especially beneficial in Google Sheets, where may want to minimize confusion by limiting the amount of data you actually include in the spreadsheet. By adding a link to your data you provide access to the information on that link while actually only showing the linked data itself.
How to Add a Hyperlink to a Cell in Google Sheets
The steps in this tutorial were performed in the desktop version of the Google Chrome Web browser, but will also work in other desktop browsers like Firefox or edge. Note that this guide assumes you know the URL for the page that you wish to link to, or that you have it open in another browser tab where you can copy and paste it.
Step 1: Sign into your Google Drive at https://drive.google.com and open the Sheets file where you want to add the hyperlink.
Step 2: Click the cell where you wish to add the link.
Step 3: Select the Insert link button in the toolbar above the spreadsheet.
Step 4: Type or paste your URL into the Link field, then click the Apply button.
Note that you can also add a hyperlink to a selected cell by pressing Ctrl + K on your keyboard, or by selecting the Edit tab and choosing the Link option.
Is there data in your spreadsheet that you don’t want to show, but you also don’t want to delete? Find out how to hide a row in Google Sheets if there is data that you don’t want your readers to view.