Insert link
You can insert hyperlinks (links to a web page) and links to another place in a document and perform various actions with them.
A hyperlink is text with a link to a URL in the following formats:
A link to another place in a document is text with a link to a sheet, named range, cell, or range in the current file.
Insert a link to a web page
- Set the cursor in the cell text or select the cell.
- In the context menu, select Insert link.
- In the Insert link window, on the Web page tab, enter the link text and address.
- Click OK.
You can also enter or paste the full URL of the link (see above) or use:
- The Link tool on the Insert tab.
- The keyboard shortcut
Ctrl+K(Cmd+K).
Insert a link to a place in the document
- In the Insert link window, on the Place in this document tab, enter the link text.
- In the Link to list, select Sheet, Named range, Cell, or Range.
- Select the target sheet, range, or cell address.
- Click OK.
Edit a link
- Place the cursor in the cell text.
- Hover over the link.
- In the pop-up window, click
Edit Link.
- Edit the text or address of the link.
- Click OK.
You can also use:
- The Edit link tool in the context menu.
- The Link tool on the Insert tab.
- The keyboard shortcut
Ctrl+K(Cmd+K).
Copy a link
- Hover the cursor over the link.
- In the pop-up window, click the
Copy link button.
You can also use the Copy link tool in the context menu.
Open a link
- Hover the cursor over the link.
- In the pop-up window, click its address.
You can also use the Open Link tool in the context menu or hold down the Ctrl (Cmd) key and click on it.
Delete link
- Set your cursor in the cell text.
- Hover the cursor over the link.
- In the pop-up window, click
Delete link.
You can also use the Delete link tool in the context menu.