tableHome Edition macOS

Hyperlinks

Product:

Application: Spreadsheet Home Edition macOS

You can add a hyperlink to a web page or an email address to the document.

MyOffice Spreadsheet recognizes and makes active hyperlinks that start with www, http, https, ftp, as well as email addresses.

Examples of the links:

•www.website.ru

•https://website.com

•http://website.ru

•ftp://192.100.0.0

•mailto:user@domain.ru

•user.name@domain.com

To avoid errors when clicking on hyperlinks, it is recommended to specify the protocol before the URL. For example: http://website.ru.

Insert a hyperlink

The hyperlink can be displayed in the document as follows:

•URL: For example, http://www.website.ru.

•Text: For example, hyperlink.

To add a hyperlink to a document as URL, follow these steps:

1.Copy the link from the source.

2.Switch to the edit mode of the cell where you want to insert the hyperlink.

3.Paste the hyperlink and press Space or enter Enter.

To add a text hyperlink to a document, follow these steps:

1.Copy the link from the source.

2.Specify the place to insert the hyperlink in one of the following ways:

•To format all text in a cell as a hyperlink, select the cell.

•To format a single word within text in a cell as a hyperlink, place the cursor in the word or select the whole word.

•To format some part of the text in a cell as a hyperlink, select that part of the text entirely.

•To insert a word or text with a hyperlink into an empty cell, select the cell or place the cursor in it.

3.Insert a hyperlink in one of the following ways:

•In the Command menu, select Insert > Link.

•On the Toolbar, in the Insert section, click t_more . In the insert pane that appears, click t_insert_hyperlink Link.

•Right-click to open the context menu and run the Insert Link context menu command.

•Press the command Cmd+K.

4.In the Insert Link window:

•Ensure that Web Page is selected in the Link to field or select this value from the drop-down list.

•If the URL field it is not filled in, insert a link into it. By default the link copied during the first step is automatically inserted into the URL field.

•If the Text field if it is not filled in, enter the text that will be displayed in place of the hyperlink URL. By default, the Text field is automatically filled with text from the selected cell or text selected in the cell or the word where the cursor is positioned.

•Click OK.

When you save an .ods document in .xlsx format in a cell that contains multiple links at the same time, only the first link remains functional.

Go to the link

To follow the link, click it while holding down the command Cmd.

Web links open in the browser that is used in the operating system by default.

When you click on the link to the email address, the mail program opens, which is used by default in the operating system. In this program, a new email is automatically created, and the To field is filled with the email address specified in the link.

Copy a hyperlink

To copy a hyperlink, right-click it and execute the Copy Link URL context menu command.

Edit a hyperlink

To edit the URL and hyperlink text, follow these steps:

1.Specify the hyperlink to edit:

•If the cell contains only the desired hyperlink, select the cell or place the cursor on the hyperlink or select the hyperlink partially or entirely.

•If the cell contains more than just a hyperlink, switch to cell editing mode and place the cursor on the hyperlink or select the hyperlink partially or entirely.

2.Open the hyperlink editing window in one of the following ways:

•In the Command menu, select Insert > Link.

•On the Toolbar, in the Insert section, click t_more . In the insert pane that appears, click t_insert_hyperlink Link.

•Right-click the selected cell and execute the Edit Link context menu command.

•Press the command Cmd+K.

3.In the Edit Link window:

•In the URL field, edit the URL of the hyperlink.

•In the Text field, edit the text that is displayed instead of the hyperlink URL.

•Click OK.

Delete a hyperlink

You can delete a hyperlink using the editing window or the context menu. The hyperlink is deleted without the text that contains it.

To delete a hyperlink using the editing window, follow the steps below:

1.Specify the hyperlink that you want to delete:

•If the cell contains only the desired hyperlink, select the cell or place the cursor on the hyperlink or select the hyperlink partially or entirely.

•If the cell contains more than just the desired hyperlink, place the cursor on the hyperlink or select the hyperlink partially or entirely.

2.Open the edit hyperlink window in one of the following ways:

•In the Command menu, select Insert > Link.

•On the Toolbar, in the Insert section, click t_more . In the insert pane that appears, click t_insert_hyperlink Link.

•Right-click to open the context menu and run the Edit Link command.

•Press command Cmd+K.

3.In the Insert Link window, do one of the following:

•In the URL field, delete the URL of the hyperlink.

•Click delete_hyperlink .

4.Click OK.

To delete a hyperlink using the context menu, follow these steps:

1.Specify the hyperlink to delete as described above.

2.Right-click to open the context menu and select Remove Link.

To delete multiple hyperlinks at once, follow these steps:

1.Select the cells that contain these hyperlinks.

2.Right-click to open the context menu and select Remove Links.

If you want to delete a hyperlink together with the text that contains it, proceed as follows:

1.Specify the hyperlink that you want to delete:

•If a cell contains only a hyperlink, select that cell or go into cell edit mode and select the entire hyperlink.

•If the cell contains more than just the hyperlink, go to the cell edit mode and select the entire hyperlink.

2.Press Delete.

Was this helpful?

Yes