Select the cell where you want to insert the internal link;
Go to the Insert menu → Link or use the keyboard shortcut Ctrl + K (Windows) or Cmd + K (Mac);
In the window that opens, in the Link field, enter the address of the cell or range on another sheet using the format:
SheetName!CellReference, for example, Sheet2!A1.
If the sheet name contains spaces, use quotes: ’Internal Link Source’!A1;
In the Text field, enter the text that will be displayed in the cell (if needed);
Click Apply to add the link.
You can also select a cell or range by clicking Sheets and named ranges and then choosing the needed cells.

You can insert a link to cell A2 on the Inserting Internal Hyperlinks sheet so that when you click the text, it takes you directly to cell A2 on the Internal Link Source sheet.

Adding External Links

Adding external links allows you to create a link to resources outside the document, such as other documents or websites.

Select the cell where you want to insert the external link;
Go to the Insert menu → Link or use the keyboard shortcut Ctrl + K (Windows) or Cmd + K (Mac);
In the window that opens, in the Link field, enter the URL of the external site or document:
- To add a link to another website, enter the URL, for example, https://www.example.com;
- To add a link to another Google Document, use the name of your document (for example, Trimming Whitespaces from the last lesson) or the full link to the document, which looks like this: https://docs.google.com/document/d/your-document-id;
In the Text field, enter the text that will be displayed in the cell (if needed);
Click Apply to add the link.

When you click the link text, you will be able to visit the specified website or document located outside of the current spreadsheet.

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 3. Розділ 3