Updated: November 17, 2026

If you need to know how to insert hyperlink in Google Sheets, the fastest path is to decide whether you want a clickable web address, a link to another file, or a jump to another cell in the same spreadsheet. Google Sheets handles all three, but the steps are different. Once you know which kind of link you need, you can add it in seconds and keep your sheet easier to navigate.

Insert a clickable web link in a cell

Use this when you want a URL, document link, or website address inside a cell. This is the standard answer for how to insert link in Google Sheets, how to add link in Google Sheets, and how to put link in Google Sheets.

  1. Click the cell where you want the link.
  2. Press Ctrl + K on Windows or Command + K on Mac.
  3. Paste the full URL into the link box.
  4. If you want the cell to show different text, type it in the text field before saving.
  5. Click Apply.

You can also paste a URL directly into a cell, then press Enter. Sheets turns it into a clickable link automatically. That answers the common query about how to paste link in Google Sheets without using the link menu.

How to name a link in Google Sheets

If you want readable text instead of a raw URL, highlight the text in the cell first, then use the link shortcut. In the link box, paste the address and keep the text you selected. This is how to add a link to text in Google Sheets and how to name a link in Google Sheets without showing the full web address.

Link to another cell in the same sheet

When people ask how to link cells in Google Sheets, how to link cell in Google Sheets, or how to link two cells in Google Sheets, they usually want one cell to jump to another location in the same workbook. The cleanest method is to use a cell reference with a formula.

  1. Click the cell where you want the link to appear.
  2. Type =HYPERLINK(“#gid=0&range=A1″,”Go to A1”) if you want a custom clickable label.
  3. Replace A1 with the destination cell.
  4. Replace Go to A1 with the text you want shown in the cell.
  5. Press Enter.

For links within the same sheet, a simpler option is to use a plain cell reference like =A1. That displays the value from A1, but it does not create a clickable jump link. If you want a real navigation link, use HYPERLINK.

How to go to linked cell in Google Sheets

Click the linked text or cell. Sheets opens the destination instantly and highlights the target cell. If the link points to another tab, Sheets switches tabs first, then lands on the referenced cell. This is the direct answer to how to go to linked cell in Google Sheets.

Link to another sheet or another file

You can link within the current spreadsheet or to a different spreadsheet file. This covers how to create a link in Google Sheets, how to make a link in Google Sheets, how to make a link on Google Sheets, and how to insert a link into Google Sheets when the target is not a website.

Link to another sheet tab

If the destination is a different tab in the same spreadsheet, use a sheet name and cell reference.

  1. Copy the sheet tab name exactly.
  2. Use a formula like =HYPERLINK(“#’Sheet2′!A1″,”Open Sheet 2”).
  3. Press Enter.

If the sheet name has spaces, keep the single quotes around it. This gives you a labeled jump link that opens the exact cell you chose.

Insert a file link in Google Sheets

To add a link to another Google Drive file, copy the file’s share link first, then place it in a cell using the link shortcut or the HYPERLINK formula. If you want a descriptive label, type that label in the cell and attach the file URL to it. This is the practical method for how to insert file link in Google Sheets and how to copy link in Google Sheets for reuse elsewhere.

Use the HYPERLINK formula for flexible links

The HYPERLINK function gives you more control than the insert link menu. It is the best choice when you want a formula-driven link that changes with your data, such as a report URL built from a cell value. It also answers how to embed a link in Google Sheets when you need the link itself to be part of the cell formula.

The basic format is:

=HYPERLINK(“URL”,”Display text”)

Examples:

  • =HYPERLINK(“https://example.com”,”Open site”)
  • =HYPERLINK(“#gid=123456789&range=B5″,”Jump to summary”)
  • =HYPERLINK(A2,”Open from cell A2″)

Use this method when you need to add link into Google Sheets across many rows. You can fill the formula down a column and keep the display text consistent.

Edit, copy, and remove links

Once a link is in place, you can change it without rebuilding the cell. This section covers how to add link to Google Sheets by editing an existing one and how to copy link in Google Sheets for use elsewhere.

Edit a link

Right-click the linked cell and choose the link option, or click the link icon if it appears. Update the URL or display text, then save. If the link was created with HYPERLINK, edit the formula directly in the formula bar.

Copy a link from a cell

To copy the destination, right-click the linked cell and choose to copy the link address if available, or open the link and copy it from the browser address bar. If the link is attached to text, the text stays the same when you paste it into another cell or document, which is useful when you need the same destination repeated across several places.

Remove a link

Click the linked cell, then remove the link from the menu or delete the HYPERLINK formula. If you only want plain text, replace the formula with its displayed value.

Common problems and formatting fixes

Most link issues in Sheets come from a missing protocol, a broken cell reference, or text that does not fit the cell. Fix those first before looking for anything more complex.

Why a pasted URL does not become clickable

If Sheets does not turn the text into a link, make sure the address starts with https:// or http://. A plain domain name without the protocol can stay as ordinary text. Paste the full address again, or use Ctrl + K or Command + K to attach it manually.

Why a cell link opens the wrong place

Check the sheet name, row number, and column letter in the formula. A typo in any of those parts sends you to the wrong cell or breaks the link entirely. If the sheet name has spaces or punctuation, keep it inside single quotes.

How to keep long links readable

Use short display text instead of showing the full URL. If the text looks cramped, widen the column or wrap the text. Clean display text matters when you have several links in one sheet and want the file to stay easy to scan.

Frequently Asked Questions

How do I insert a link into Google Sheets without a formula?

Click the cell, press Ctrl + K or Command + K, paste the URL, and click Apply. That creates a clickable link without writing a formula.

How do I add a link to text in Google Sheets?

Select the text in the cell, open the link tool with Ctrl + K or Command + K, paste the URL, and save. The text becomes the clickable label.

Can I link one cell to another cell in Google Sheets?

Yes. Use the HYPERLINK formula with a cell reference, such as a link to a location in the same sheet or another tab. That is the correct method for how to link two cells in Google Sheets.

How do I insert link Google Sheets from a copied address?

Copy the URL first, then use the link shortcut in the target cell and paste it into the address box. Sheets stores the copied address as a clickable link.

How do I insert hyperlink in Google Sheets and make it jump to another sheet?

Use a HYPERLINK formula with the target sheet name and cell reference, such as #’Sheet2′!A1. That creates a clickable link to the other tab and exact cell.