You can create links to other sheets to make it easier to navigate through the document. For example, you can create a list on the first sheet with links to the other sheets of the document.
A link to a sheet may contain: •Sheet name. For example, Sheet 2. •Any other text. For example, see this sheet. To create a link to another sheet, 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, 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 > . •On the Toolbar, in the section, click button. On the insert pane that appears, click the button. •Right-click to open the context menu and execute the command. •Press +. 3.In the window, in the drop-down list, select the value . 4.In the drop-down list, select the sheet to which you want to create a link. To quickly find a sheet, enter part or the entire name of the desired sheet in the field. 5.In the field: •If the field is not filled in and you want to create a link with the sheet name, leave the field blank. •If the field is not filled in and the link text is required, enter the 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. 6.Click . 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.
|
To follow the link, click it while holding down the pressed. |
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 > . •On the Toolbar, in the section, click button. On the insert pane that appears, click the button. •Right-click to open the context menu and run the command. •Press +. 3.In the window: •In the field, if necessary, select another sheet of the document. •In the field, edit the link text if necessary. •Click . |
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 > . •On the Toolbar, in the section, click button. On the insert pane that appears, click the button. •Right-click to open the context menu and run the command. •Press +. 3.In the window, do one of the following: •In the field, click the button. •Click button. 4.Click . 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 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 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 or . |