How to Insert a Hyperlink in Google Sheets

A Google Sheets spreadsheet doesn’t have to be a closed ecosystem of just numbers and formulas. You can turn any cell into a clickable gateway to the rest of the internet by inserting a hyperlink. Whether you are creating a project tracker that links to external research documents, or a budget that links to online receipts, adding hyperlinks makes your spreadsheets significantly more useful and interactive.

Method 1: The Insert Menu (The Standard Way)

This is the most traditional way to add a link to a cell.

1. Open your Google Sheets document.
2. Click on the specific cell where you want the link to appear. (You can type text into the cell first, such as “Click Here for Report,” or you can leave it blank).
3. Look at the menu bar at the very top of the screen and click on Insert.
4. From the drop-down menu, scroll down and click on Link.
5. A small dialogue box will appear near the cell. It has two fields:
   • Text: This is the visible text that people will see in the spreadsheet (e.g., “Company Website”). If you already typed text in the cell, it will appear here.
   • Link: This is the actual destination URL (e.g., “https://www.google.com”).
6. Paste your desired URL into the “Link” box.
7. Click the Apply button.
8. The text in the cell will turn blue and become underlined, indicating it is now a clickable hyperlink.

Method 2: The Keyboard Shortcut (The Fastest Way)

If you work with a lot of links, using the keyboard shortcut is significantly faster than navigating the menus.

1. Click on the cell you want to turn into a link.
2. Press the following keys simultaneously:
   • On Windows or Chromebook: Ctrl + K
   • On Mac: Cmd + K
3. The “Insert link” dialogue box will instantly appear.
4. Paste your URL into the bottom box and press the Enter key to apply it.

How to Link to Another Sheet (Tab) in the Same Document

Hyperlinks aren’t just for external websites. You can use them to build an interactive “Table of Contents” that jumps between different tabs within the same spreadsheet.

1. Select a cell and press Ctrl + K (or Cmd + K) to open the link box.
2. Look at the bottom of the link dialogue box for an option labeled Sheets and named ranges. Click it.
3. A list will appear showing all the different tabs (sheets) currently in your document (e.g., “Sheet1”, “Q3 Budget”, “Employee Roster”).
4. Click on the name of the tab you want to link to.
5. Google Sheets will automatically format the link. Now, whenever someone clicks that cell, they will be instantly teleported to that specific tab.

How to Edit or Remove a Hyperlink

If you made a mistake or the web address changes, fixing it is easy.

1. Click once on the cell containing the hyperlink.
2. A small preview box will pop up displaying the URL.
3. To change the link, click the Edit link icon (it looks like a small pencil).
4. To completely delete the link and turn it back into normal text, click the Remove link icon (it looks like a broken chain link).