HYPERLINK: make the destination obvious
A spreadsheet link should tell the reader where it is going. HYPERLINK separates the address from the text shown in the cell, but it does not validate a destination.
The friendly label can differ from the destination. For an internal Excel workbook reference, the leading # identifies a location inside the workbook. A link may still look correct if its sheet has been renamed and the text target was not updated, so click-test navigation after structural changes.
| Formula | Expected result / interpretation |
|---|---|
| =HYPERLINK(“#’Order Log’!A1″,”Open order log”) | Displays Open order log and targets A1 on Order Log |
| =HYPERLINK(“https://celllingo.online/formula-checker/”,”Check a formula”) | Displays Check a formula and targets the named web page |
| Purpose | Target |
|---|---|
| Internal destination | #’Order Log’!A1 |
| Displayed text | Open order log |
Create a worksheet named Order Log. The space in its name means the sheet name should be enclosed in single quotes inside the target string.
Create a readable jump to an internal sheet
Formula syntax
=HYPERLINK(link_location, [friendly_name])
What goes into it
link_location
URL, file path or workbook location to open.
friendly_name
Optional text or value displayed in the cell.
A quick example first
=HYPERLINK("https://example.com","Open site")
Displays “Open site” and links to the URL.
=HYPERLINK("#Sheet2!A1","Go to Sheet2")
Links to a location inside the same workbook.
Before you copy this into a real sheet
Do not treat a hyperlink label as proof that a destination is safe or available. Avoid constructing links from untrusted imported text without checking the allowed scheme and host. Excel for the web supports web URL targets for HYPERLINK; use desktop Excel for this internal-sheet example. Local-file links also depend on client access. This example is Excel syntax; Google Sheets uses different link conventions. For distributed workbooks, prefer destinations that recipients can actually access.
Useful habits
- Use the # prefix for internal workbook locations.
- Keep displayed text consistent with the actual destination.
- Paths to local/network files may break when a workbook is moved or shared.
Where people get caught out
- Forgetting quotation marks around a literal URL.
- Assuming friendly_name changes the destination rather than only the displayed text.
Other functions worth a look
A detail worth remembering
Review links before sharing a workbook. A valid formula can still point to an outdated file, a private location or the wrong website.
Reference and examples
The examples above use small, invented datasets and English-language formula names. Check your Excel version and argument separator against the official Excel function reference if a formula behaves differently on your computer.