Course contents · Import, templates, protection

Hyperlinks, objects and text boxes

Open the practice in the trainer →

Hyperlinks

Insert → Link or Ctrl+K. A hyperlink can point to:

With a formula: =HYPERLINK("#Report!A1", "Go to report").

Embedding objects

Insert → Text → Object embeds a Word document, PDF or another workbook. “Link to file” shows the current version of the source; without a link you get a copy inside the workbook.

Text boxes

Insert → Text Box — a freely movable block of text over the cells: explanations, user instructions. A text box can be linked to a cell: select it and type =B5 in the formula bar.

Tasks in the trainer

  1. Table of contents: in B2:B4 create links to cell A1 of the sheet named in column A, labelled “Go to: name”.
  2. In F2:F4 create mailto: links to the addresses in column E, labelled “Write to surname”.
  3. In I2 — a link to the website in H2 labelled “Excel help”.
  4. Text for a text box linked to a cell: in B6 build “Sections: 3”, counting the sections with a formula.
  5. In B7 count the addresses in the company.com domain (wildcard *).

Solve the tasks in the trainer →

Check yourself

  1. Which shortcut inserts a hyperlink?
  2. How do you make a text box show the value of cell B5?
  3. You embedded a Word document with “Link to file”. What happens if the source changes?