Links
You can add a link to a web page, an email address, a place in the current document, or other file to a document.
Insert a link to a web page or email address
MyOffice Spreadsheet 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, To avoid errors when you click links, it is recommended to specify the protocol in the URL. For example, http://website.com.
The link can be displayed in the document as follows: •URL: For example, http://www.website.com. •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. 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: •In the Command menu, select Insert > Link. •On the Toolbar, in the Insert section, click •Right-click to open the context menu and select the Insert Link command. •Press Ctrl+K. 4.In the Insert Link window, on the Web Page or File tab: •If the Address field 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 field. •If the Text field 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 field. •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.
|
Insert a link to a place in the document
To help you navigate through particularly long documents, you can also create links to a specific place in the document, for example, to a sheet, a cell, a range of cells, or a named range. A link to a place in a document may contain the following elements: •Sheet name. For example, Sheet 2. •Name of the sheet with the cell or range address. For example, 'Sheet 2'!A3:A6. •Name of the named range. For example, Range 1. •Any other text. For example, see here. To create a link to a place in the document, follow the steps below: 1.Specify the place to insert the link in one of the following ways: •To create a link with the sheet name and cell address/range, select an empty cell or, if the cell is not empty, place the cursor in the desired cell position. •To add a word or text with a link to an empty cell, select the cell or place the cursor in it. •To format all text contained in a cell as a link, select the 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. 2.Insert the link in one of the following ways: •In the Command menu, select Insert > Link. •On the Toolbar, in the Insert section, click •Right-click to open the context menu and select the Insert Link command. •Press Ctrl+K. 3.In the Insert Link window, select the Place in This Document tab. 4.To insert a link to a sheet, make sure the Sheet radio button is selected and choose the desired sheet from the list. 5.To insert a link to a cell or range in the Cell or Range field, enter the cell/range address manually. Or click 6.To insert a named range reference, click the Named range radio button and select the desired range from the list below. 7.In the Text field: •If the field displays the sheet name and the selected range and you want to create a link with the sheet name, leave the content of the field unchanged. •If the field displays the sheet name and the selected range but you want to specify the link text, enter the required text manually. •If the field is filled with text from the selected cell or text selected in the cell, or a word on which the cursor is positioned, edit this text if necessary or leave it unchanged. 8.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.
|
Insert a link to a file
You can insert a link to a file that is located on the current computer or in a network folder into your document. The link can reference a file of any format. The link can be displayed in the document as follows: •Paths to the file. For example, C:\Users\User\Documents\File.xlsx (Windows) or /Users/User/Downloads/File.xlsx (Linux). •Text: For example, link to the file. You can specify the text of the link either in the cell or in the link insertion window. To add a link to a file in your document, follow these steps: 1.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. 2.Insert the link in one of the following ways: •In the Command menu, select Insert > Link. •On the Toolbar, in the Insert section, click •Right-click to open the context menu and select the Insert Link command. •Press Ctrl+K. 3.In the Insert Link window, on the Web Page or File tab, select the file to which you want to insert a link using one of the following methods: •Select a file from the Recent Files list. This list shows the 50 most recent files that were opened in MyOffice Spreadsheet, MyOffice Text and MyOffice Presentation applications. The Recent Files list does not include files that have been opened from the Cloud. To insert a link to a file from the Cloud, copy the link address of the file in your browser and paste it into your document as a link to a web page.
•Select the file using the File manager. To do this, click Choose File button. • 4.If you want the link to be displayed as text and the Text field is not filled in, enter the required text. 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 field. 5.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.
|
Quick link insertion
You can quickly add a link to a web page, email address, or file to the typed text. For quick insertion, the following types of links to local and network files are supported: •file:///C:/Users/User/Documents/File.xlsx •smb://192.168.1.1/Files/File.xlsx •ftp://Guest@127.0.0.1/share/FTP/File.xlsx •sftp://Guest@127.0.0.1/share/FTP/File.xlsx The supported types of web page links and email addresses are described in the section above. To quickly add a link to typed text, follow these steps: 1.Copy the link. 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. 3.Press Ctrl+Shift+V. |
Go to the link
To follow the link, click it while holding down the Ctrl pressed. Web links are opened in the default browser used in the OS. Files are opened in MyOffice Spreadsheet, MyOffice Text and MyOffice Presentation applications. If the file format is not supported, the file is opened in the application that is used by default in the OS to work with files of the corresponding format. When you click the link to an email address, it opens the default email client in your OS. This software automatically creates a new email, into which the data specified in the link is copied. When you click a link to a place in the document, a sheet with the corresponding cell, cell range, or named range opens. |
Copy a link
To copy a link, right-click it and in the Context menu, select Copy Link URL. Copying links via the context menu is not supported for links to sheets and cells.
|
Edit a link
To edit a link, follow the steps below: 1.Specify a link to edit: •If a cell contains only a link, select that cell or place the cursor on the link, or select part of the link/the entire link. •If the cell contains more than just a link, place the cursor on the link or select part of the link/the entire link. 2.Open the link editing window in one of the following ways: •In the Command menu, select Insert > Link. •On the Toolbar, in the Insert section, click •Right-click to open the context menu and select the Edit Link command. •Press Ctrl+K. 3.In the Edit Link window, make the desired changes. 4.Click OK. |
Delete a link
The link can be deleted using the edit window or the context menu. The link is deleted without the text that contains it. To delete a link using the edit window, follow these steps: 1.Specify the link to delete: •If a cell contains only a link, select that cell or place the cursor on the link, or select part of the link/the entire link. •If the cell contains more than just a link, place the cursor on the link or select part of the link/the entire link. 2.Open the link editing window in one of the following ways: •In the Command menu, select Insert > Link. •On the Toolbar, in the Insert section, click •Right-click to open the context menu and select the Edit Link command. •Press Ctrl+K. 3.In the Edit Link window, click the Remove Link button. To delete a link using the context menu, follow these steps: 1.Specify the link to delete as described above. 2.Right-click to open the context menu and run the Delete Link command. To delete multiple links at the same time, follow these steps: 1.Select the cells that contain the link data. 2.Right-click to open the context menu and run the Delete Links command. If you want to delete the link along with the text that contains it, follow these steps: 1.Specify the link to delete: •If a cell contains only a link, select that cell or switch to cell editing mode and select the entire link. •If the cell contains more than just a link, switch to the cell editing mode and select the entire link. 2.Press Delete or Backspace. |
Keyboard shortcuts for moving between window elements
The table below shows the keyboard shortcuts you can use to quickly move between elements in the Insert/Edit Link window.
|
