You can insert a link to a web page or place in a document and perform various actions with it.
Prepare a cell
Before inserting a link, prepare the cell in one of the following ways:
–Select an empty cell or place the cursor in the cell.
–If the cell is not empty, place the cursor where the link should be.
–To format all existing text in a cell as a link, select the cell.
Open the Insert link window
To open the Insert link window, use one of the following methods:
–On the Insert tab, click the Link button.
–Right-click and select Insert link from the context menu.
–Press the keyboard shortcut Ctrl+K (Cmd+K).
Insert a link using the command 1.Open the Insert link window. 2.In the window, enter the link text and URL. 3.Click OK. Insert a link directly 1.Position the cursor at the location to insert. 2.Enter the full URL. 3.Press Space or Enter. Specifics of inserting a hyperlink –To create an active link, specify a protocol (e.g., https://website.ru). –URLs like www.website.ru and user.name@domain.ru are automatically recognized. |
1.Open the Insert link window. 2.Click the Place in this document. 3.In the Link to list, select the target of the link: •Sheet: select the desired sheet from the list. •Named range: select the range from the list. •Cell or range: enter the address manually or click the select button and specify the cells in the document. 4.In the Text field, specify the link text in one of the ways: •Leave the field blank to use the default sheet name. •Enter your own text. •If the field is already filled in (with text from the cell), edit it if necessary. 5.Click OK to insert the link. |
1.From the context menu, select Edit link. 2.In the Edit link window, make your changes. 3.Click the OK button. |
To copy the link address to the clipboard, use one of the methods: –Hover over the link and in the pop-up window, click Copy link. –From the context menu, select Copy link. |
To follow a link, use one of the following methods: –Hover over the link and in the pop-up window, click the link address. –From the context menu, select Open link. –Click the link while holding down the Ctrl (Cmd) key. |
To delete a link, use one of the following methods: –Place the cursor in the cell with the reference and delete its text. –Select the cell with the reference and press the Delete key. |