With the ribbon command Insert | group Links | Hyperlink you can add a hyperlink to cell contents or complete cells at any time. Hyperlinks are links to e.g. websites or other documents, which can then be opened simply by clicking on the link.
If, for example, you link a cell to a web page, the web browser will automatically start when you click on this link and will access this page in it.
By the way, the file path of another document is also allowed as a destination for hyperlinks. This is then opened automatically when you click on the link.
Tip: It is also possible to use an e-mail address as a destination by placing "mailto:" in front of it.
Creating a hyperlink
To create a hyperlink, proceed as follows:
| 1. | Select the cell or cell contents to which you want to attach a hyperlink. |
| 2. | Choose the ribbon command Insert | group Links | Hyperlink  . |
| 3. | For URL or file name, specify the destination for the hyperlink: Enter the path and name of the Internet resource or file to which you want the selected text to refer. |
| For links to web pages, "http://" and the address of the page should be entered – for example, "http://www.example.com". |
| For links to an e-mail address, enter "mailto:" and the recipient's address – for example, "mailto:xy@example.com". |
| For links to a file, the Browse button can be used. |
| 4. | In the Jump target field, you have the option of specifying the target position (a bookmark or a cell address) in the document to be opened (see below). However, this field is usually left empty. |
| 5. | Confirm with OK. |
| Note: The Reset button allows you to undo all changes made in the open dialog box provided that you have not yet confirmed them with OK. |
The hyperlink is now created. You recognize this by a change in the color of the text, which indicates the presence of a link.
Tip: Alternatively, hyperlinks can also be added using the HYPERLINK function (which is much more flexible)
Jumping to specific bookmarks or cell references
The aforementioned dialog box also gives you the option of specifying the jump target in the document to be opened, if necessary. For Jump target, enter the bookmark (for HTML documents) or the cell address (for PlanMaker documents) to which you want to jump.
For example: If you set URL or file name to "Sales.pmdx" and under Jump target you enter "D42", the link will open the file Sales.pmdx and jump to cell D42.
Using placeholders in links
Tip: In hyperlinks, you can use an asterisk (*) as a placeholder for the cell content.
Example:
If the cell is still empty, choose the ribbon command Insert | group Links | Hyperlink and enter http://* in the URL or file name box. After that, if you enter e.g. www.example.com in that cell, the link will point to the Internet address http://www.example.com.
This also works with other protocols – for example mailto:* can be used to create a link to the e-mail address in a cell.
Opening hyperlinks
To open a hyperlink, simply click on the cell or text containing the hyperlink with the mouse. PlanMaker then opens the linked document.
Editing or removing a hyperlink
Existing hyperlinks can be edited as follows:
▪Changing destination
| To change the destination of a hyperlink, select the cell(s) or text passage with the link and then choose the ribbon command again Insert | group Links | Hyperlink. The program again displays the dialog box in which you can edit the destination for the link. |
To remove a hyperlink, proceed as follows:
▪Removing a hyperlink by deleting the link text/cell
| If you delete a cell or text passage that contains a hyperlink, the link is also removed. |
▪Removing only the hyperlink
| If you only want to remove the hyperlink, but retain the associated cell or text passage, select it and choose the ribbon command Home | group Contents | Delete | Remove link. |