Formatting: Hyperlinks

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:

You can explicitly specify the link type by using one of the following prefixes:

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.

*