Choose the ribbon command Insert | group Links | Hyperlink to add a hyperlink to cell contents or complete cells at any time. Hyperlinks are links to, for example, 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. | Optional: In the Jump target field, you have the option of specifying a bookmark or a cell address in the document to be opened (see below). However, this field is usually left empty. |
| 5. | Optional: In the Hyperlink text field, you can change the text for the cell you have just selected in the document. If the cell is empty, PlanMaker automatically inserts the selected path and file name or Internet address as text. |
| 6. | 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. (Provided that there is text in the cell.)
Tip: Links to URLs and e-mail addresses can be created faster and easier if the option Format URLs as hyperlinks is enabled in the dialog box of the ribbon command Review | Auto correction. You can then type the destination address (for example, "www.example.com" or "mailto:xy@example.com") directly into the text and press the space bar. PlanMaker recognizes that you have entered a web address or e-mail address and automatically formats it as a link. This setting is global and not document-specific.
Tip: Alternatively, hyperlinks can also be inserted using the HYPERLINK function, which is much more flexible to use.
Jumping to a specific bookmark or cell address
The aforementioned dialog box also gives you the option of specifying a jump target if necessary in the document to be opened. For Jump target, enter the bookmark (for TextMaker or 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 enter "D42" under Jump target, the link will open the file Sales.pmdx and jump to cell D42.
Using wildcards in links
Tip: In hyperlinks, you can use an asterisk (*) as a wildcard 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. If you then 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 Insert | group Links | Hyperlink again. 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 text passage that contains a hyperlink, the link will also be removed. If a cell is deleted completely, this also removes the hyperlink applied to the cell. |
▪Removing only the hyperlink
| If you only want to remove the hyperlink from the cell, but retain the cell itself and its contents, select it and choose the ribbon command Home | group Contents | Delete | Remove link. |