Links to sheets

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 Insert > Link.

•On the Toolbar, in the Insert section, click button. On the insert pane that appears, click the  Link button.

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

•Press  Cmd+K.

3.In the Insert Link window, in the Link to drop-down list, select the value Sheet.

4.In the Sheet 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 Sheet field.

5.In the Text 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 OK.

To follow the link, click it while holding down the  Cmd 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 Insert > Link.

•On the Toolbar, in the Insert section, click button. On the insert pane that appears, click the  Link button.

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

•Press  Cmd+K.

3.In the Edit Link window:

•In the Sheet field, if necessary, select another sheet of the document.

•In the Text field, edit the link text if necessary.

•Click OK.

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 button. On the insert pane that appears, click the  Link button.

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

•Press  Cmd+K.

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

•In the Sheet field, click the button.

•Click button.

4.Click OK.

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.