In MyOffice Spreadsheet, you can add a link to a web page or to an email address.

MyOffice Spreadsheet detects and activates the links starting with www, http, https, and ftp, as well as email addresses.

Here are the examples of the links:

www.website.com

https://website.com

http://website.com

ftp://192.100.0.0

mailto:user@domain.com

user.name@domain.com

Specify the URL protocol to ensure that the links open correctly. For example: http://website.com.

Insert a link

In MyOffice Spreadsheet, links can be displayed as follows:

URL: http://www.website.com

Text: Link

To insert a URL link, follow the steps below:

1. Select a cell where you want to insert a link and enter the cell editing mode.

2. Enter a URL link.

3. Press Enter.

To insert a text link, follow the steps below:

1. Select a cell where you want to insert a link.

2. Insert a link in one of the following ways:

In the Insert menu, click Link.

On the Toolbar, select the Insert section and click t_insert_hyperlinkLink.

On the Toolbar, select the Insert section and click t_more. In the opened insert pane, click t_insert_hyperlinkLink.

Right-click the selected cell and select the Insert Link option from the context menu.

Press Ctrl+K.

3. In the Insert Link pop-up window, enter the URL in the URL box.

4. In the Text box, enter the text to be displayed instead of the link.

5. Click OK to insert a link or Cancel to cancel the insertion.

It is possible to insert multiple links in one cell.

Edit a link

To edit a link and a URL text, do the following:

1. Select a cell containing the link that you want to edit.

2. To call the Edit Link pop-up window, do one of the following:

In the Insert menu, select Link.

On the Toolbar, select the Insert section and click t_insert_hyperlinkLink.

On the Toolbar, select the Insert section and click t_more. In the opened insert pane, click t_insert_hyperlinkLink.

Right-click the selected cell and select the Edit Link option from the context menu.

Press Ctrl+K.

3. In the Edit Link pop-up window, edit the Url in the URL box.

4. In the Text box, edit the text to be displayed instead of the link.

5. Click OK to save the changes.

Go to the link

To go to the link, left-click it while holding down the Ctrl key. The page opens in the default browser.

Clicking the email address link will open the default email application. A new outgoing email message will be created where the To field is filled with the email address specified in the link.

Copy a link

To copy a link, click it with the right mouse button and select the Copy Link URL command in the context menu.

Was the material useful?
Yes
No
Users found this material useful: 0 из 0