How to Create Hyperlinks in Google Sheets (Step-by-Step Guide)

Hyperlinks in Google Sheet Cells: Hyperlinks help us to navigate the user from one to another page. Usually, the hyperlinks are commonly seen on Web pages. However, Google Sheets also allows using the text with hyperlinks with the help of which users can navigate from page to page.

Let’s understand how to create and edit hyperlinks with the Google Sheet tips provided on this page.

Table of Contents

We can add hyperlinks to Google Sheets with the help of any of the following two methods such as:

  • Using Insert Menu
  • Using Hyperlink Formula

The steps to add hyperlinks to the Spreadsheet using the menu option are explained below:

  • Step 1: Select the cell where you want to create a hyperlink.
  • Step 2: Now click on the “Insert” menu and select “Link” from the drop-down menu.

hyperlinks-in-google-sheets

  • Step 3: A dialog box opens on the screen. Paste the URL and press Apply button. The hyperlink is created.

hyperlinks-in-google-sheets

 

We can also create a hyperlink to desired text by following the steps listed below:

  • Step 1: Select the cell.
  • Step 2: Now enter the formula as HYPERLINK(URL, LINK_LABEL). In the URL part, paste the URL, and in the Link_Label Part, enter the text for which hyperlink should be created.
  • Step 3: Press the “Enter” button. You will see the results.

hyperlinks-in-google-sheets

We can also hyperlink another Google Spreadsheet in this Google Sheet. The steps to hyperlink another sheet in Google Sheets are explained below:

  • Step 1: Select the cell where you want to insert the hyperlink.
  • Step 2: Now click on the “Insert” tab and select “Link” from the dropdown.

hyperlinks-in-google-sheets

  • Step 3: Then select Sheets in this spreadsheet option from the hyperlink dialog box.
  • Step 4: Now under the link option, type the sheet name.
  • Step 5: Here a list of sheets with a similar name will open on the screen. Now select the sheet name and click on “Apply“.
  • Step 6: The hyperlink will be applied.

hyperlinks-in-google-sheets

We can also apply hyperlinks to a range of cells in Google Sheets by following the steps listed below.

  • Step 1: Select the cells to insert the hyperlinks.
  • Step 2: Now go to the “Insert” option and select “Insert link.

hyperlinks-in-google-sheets

  • Step 3: Hyperlink dialog box opens on the screen. Now choose to Select a range of cells to link from the options.
  • Step 4: Now enter the cell range and specify the URL to be linked.
  • Step 5: Click on the “Apply” button and the hyperlinks will be applied to the selected range of cells.

hyperlinks-in-google-sheets
<h3id=”Keyboard-Shortcut-to-Insert-Hyperlink”>Keyboard Shortcut to Insert Hyperlink

The keyboard shortcut to insert the hyperlinks in Google Sheets are explained below:

  • Step 1: Select the cell where you want to insert the hyperlink.
  • Step 2: Double click the cell to edit and select the text to link.
  • Step 3: Now press “Cntrl+K“.
  • Step 4: The hyperlink dialog box will open on the screen.
  • Step 5: Now paste the URL and click on “Apply“.

The hyperlink will be inserted into the desired cell.

To remove the hyperlink in Google Sheets, follow the steps as listed below:

  • Step 1: Select the cell where you want to remove the hyperlink.
  • Step 2: Now click on the “Remove hyperlink“.
  • Step 3: The selected text’s hyperlink will be removed.

hyperlinks-in-google-sheets

To remove the hyperlink in bulk, follow the steps as listed below:

  • Step 1: Select the range of cells where you want to remove the hyperlink.
  • Step 2: Now right-click and move the “Remove Link“.
  • Step 3: Click on it. The hyperlink will be removed.

hyperlinks-in-google-sheets