Open invoice PDF
=HYPERLINK("https://drive.google.com/file/d/"&B2, "View PDF") labels each invoice link.
What is HYPERLINK in Google Sheets?
HYPERLINK builds a clickable link in a cell. Pass a URL and optional friendly label text. Reports use it for open invoice, view doc, or mailto support links without ugly raw URLs filling the grid.
When to use it
Use HYPERLINK in dashboards and exports where readers should jump to source docs, forms, or filtered views with readable link text.
When to skip it
Skip HYPERLINK when plain URLs are fine for technical audiences or when link columns should stay plain text for CSV export rules.
How it works
-
1
Wrap URL in quotes as first argument, including https://.
-
2
Pass label text as second argument shown in the cell.
-
3
Build URLs with concatenation from id cells, for example file base plus doc id.
-
4
Use mailto: links with subject parameters for one-click email drafts.
-
5
Test links as viewer role, not only owner, to catch permission issues.
-
6
Pair with IMAGE in the next column for visual catalogs with click-through.
Examples in Google Sheets
Mailto support
=HYPERLINK("mailto:"&C2&"?subject=Order "&D2, "Email customer") opens a prefilled message.
Sheet deep link
=HYPERLINK("#gid="&gid&"&range=A"&row, "Go to row") jumps within a large shared workbook.
Build this without starting from a blank cell
Use a Better Sheets tool for HYPERLINK, then watch a walkthrough when you want the full pattern.
Better Sheets resources
Common mistakes
- Missing https:// so browsers treat link as relative path.
- Broken concatenation leaving double slashes or missing ids.
- Link label hiding the destination so phishing-conscious users distrust the sheet.
- mailto links with unencoded spaces breaking in some clients.
- HYPERLINK pointing at expired signed URLs in automated exports.
Frequently asked questions
- HYPERLINK vs plain URL?
- Plain URLs auto-link sometimes. HYPERLINK controls visible label text.
- Link to sheet range?
- Use hash gid and range parameters in the URL string.
- HYPERLINK array?
- Drag formula down so each row builds its own URL from cells.
- Why link does not click?
- Cell may be in edit mode, or URL string is malformed.
- HYPERLINK in conditional formatting?
- Formatting is separate. HYPERLINK is a formula returning clickable text.
- Export to Excel?
- Links often survive export but test target workbook behavior.
- HYPERLINK and IMPORTXML?
- IMPORTXML can fetch URLs while HYPERLINK makes clickable destinations in the grid.
Related Tutorials
Watch how HYPERLINK works
Creating a Custom URL Link for Your Spreadsheet
How do I reference a different spreadsheet in Apps Script?
Better Sheets Members Tour March 2026
Activate A Certain Sheet When Opening a Spreadsheet
Extract URLs from Google Sheets
Create Navigation Buttons in Sheets to Other Sheets
Related blog posts
Guides that explain HYPERLINK in more depth.
Extract URLs from Google Sheets
Extract url from hyperlink google sheets.Skip the Command K. This Google Sheet tutorial will make it easier for you to extract URLS from Google Sheets.
Read post →Make It Easier For Others To Use Your Google Sheets
In this tutorial, we're going to orient users better in Google Sheets. We want to help not just ourselves but also anyone who’s going to use a spreadsheet that we have created.
Read post →Quick Google Sheets Tips
Boost productivity and streamline your workflow in Google Sheets with our quick tips and free tools. Breathe new life into your spreadsheets today.
Read post →Related glossary terms
IMAGE
IMAGE fetches a picture from a public URL and renders it inside a cell. Modes control fit, stretch, and custom height. Product catalogs, team directories, and asset trackers use IMAGE to show thumbnails beside SKUs without manual insert image menus.
Read guide →IMPORTRANGE
IMPORTRANGE loads values from a range in another Google spreadsheet into your current file. You pass the spreadsheet URL or key plus a range string with an optional sheet name. After you grant access once, the link stays live and updates when the source changes.
Read guide →QUERY
QUERY runs a SQL-like statement against a range of cells and returns a new table of results. You pass a data range, a query string with SELECT, WHERE, ORDER BY, and optional headers. It is the fastest way to filter, sort, group, and pivot sheet data without helper columns.
Read guide →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same height as the data. FILTER spills results automatically, so it replaced many INDEX/SMALL helper-column patterns for live subsets.
Read guide →Done reading about HYPERLINK?
Membership unlocks 636+ tutorials, unlimited generators, and every template. Practical lessons. Zero fluff.
Need this once
Jump to a free tool or a single tutorial for this topic.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.