1. Overview
The Format > Hyperlink style allows you to treat cell contents as hyperlinks activated with a single click or by pressing SPACE. To edit a hyperlink, double‑click it or press ENTER/F2 (unless ENTER has been redefined in global or AutoScroll options).
2. Supported Link Types
A hyperlink may point to:
- a location in the current workbook,
- another workbook file,
- a web address,
- an e‑mail address,
- a file on a local disk,
- or any other supported protocol.
You can explicitly specify the link type by using one of the following prefixes:
- wbook:// (e.g., wbook://folder2/sheet2!b100)
- http://
- https://
- file://
- mailto:
- ftp://
- gopher://
- nntp://
- news://
- wais://
- telnet://
- prospero://
- res://
3. Navigation and Backtracking
Note: Clicking a workbook hyperlink jumps to the specified location. If the link points within the same workbook and you want to return to the previous location, click the Back bookmark button or press Alt+F11.
This jump‑back option remains available until you use any bookmark command for another purpose.
4. Creating Hyperlinks
The easiest way to create a hyperlink to the current cell is to use one of the Edit > Copy as Hyperlink commands.
To paste such a hyperlink — already formatted — into the same or another workbook, simply use the standard Paste command.
The Ctrl+H shortcut is automatically assigned to the most recently used hyperlink command variant.
