Insert a link to a web page or email address

MySpreadsheet recognizes and makes active links that start with www, http, https, and email addresses.

Examples of the links:

•www.website.ru

•http://website.ru

•https://website.com

•mailto:user@domain.ru

•user.name@domain.com

A link such as mailto:user@domain.ru may also contain a subject line, the text of the email, and email addresses for sending copy and blind copy. For example,
mailto:user@domain.ru?subject=This%20is%20the%20subject&cc=user2@domain.ru&body=This%20is%20the%20body.

The link can be displayed in the document as follows:

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

•Text: For example, link.

To add a link to your document as a URL, do one of the following:

•Enter the link manually and press Space or Enter.

•Copy the link from the source. Switch to the cell edit mode, insert the link and press Space or Enter.

•Copy the link from the source. Switch to the cell edit mode and press Ctrl+Shift+V (Windows, Linux) or Shift+Cmd+V (macOS).

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

1.Copy the link from the source.

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

•To link the entire text in a cell, select this cell.

•To format a single word in the cell text as a link, place the cursor in the word or select the entire word.

•To format a part of the text in a cell as a link, select the entire text part.

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

3.Insert the link in one of the following ways:

•On the Insert tab, click  Link.

•When working in macOS, select Insert > Link command from the command menu.

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

•Press Ctrl+K (Windows, Linux) or Cmd+K (macOS).

4.In the Insert link window, on the Web page or file tab:

•If the Address box is blank, paste a link into it. By default, the link copied from the source in the first step is automatically inserted into the Address box.

•If the Text box is not filled in, enter the text that will be displayed instead of the link. By default, text from the selected cell or the text selected in the cell or the word on which the cursor is placed is automatically inserted into the Text box.

•Click OK.