Add hyperlinks
To add a hyperlink in the Spreadsheet Editor,
- select a cell where a hyperlink should be added,
- switch to the Insert tab of the top toolbar,
- click the Hyperlink icon on the top toolbar,
- the Hyperlink Settings window will appear, and you will be able to specify the hyperlink settings:
- Select the required link type:
Use the External Link option and enter a URL in the http://www.example.com format in the Link to field below if you need to add a hyperlink leading to an external website. If you need to add a hyperlink to a local file, enter the URL in the file://path/Spreadsheet.xlsx (for Windows) or file:///path/Spreadsheet.xlsx (for MacOS and Linux) format in the Link to field.
The file://path/Spreadsheet.xlsx or file:///path/Spreadsheet.xlsx hyperlink type can be opened only in the desktop version of the editor. In the web editor you can only add the link without being able to open it.
Use the Internal Data Range option, select a worksheet and a cell range in the fields below, or a previously added Named range if you need to add a hyperlink leading to a certain cell range in the same spreadsheet.
You can also generate an external link which will lead to a particular cell or a range of cells by clicking the Get Link button or using the Get link to this range option in the contextual right-click menu of the required cell range. The Get link to this range option is also available in the viewing mode.
- Display - enter a text that will become clickable and lead to the web address specified in the upper field.
Note: if the selected cell already contains data, it will be automatically displayed in this field.
- ScreenTip Text - enter a text that will become visible in a small pop-up window with a brief note or label connected to the hyperlink.
- click the OK button.
To add a hyperlink, you can also use the Ctrl+K key combination or click with the right mouse button the position where the hyperlink should be added and select the Hyperlink option in the right-click menu.
When you hover the cursor over the added hyperlink, the ScreenTip will appear. To follow the link, click the link in the spreadsheet. To select a cell that contains a link without opening the link, click and hold the mouse button.
To delete the added hyperlink, activate the cell containing the added hyperlink and press the Delete key, or right-click the cell and select the Clear All option from the drop-down list.
Return to previous page