Hyperlinks, objects and text boxes
Open the practice in the trainer →
Hyperlinks
Insert → Link or Ctrl+K. A hyperlink can point to:
- a web page or a file;
- a place in this document — another sheet or a named range (handy for a table of contents in a big model);
- an e-mail address.
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
- Table of contents: in B2:B4 create links to cell A1 of the sheet named in column A, labelled “Go to: name”.
- In F2:F4 create mailto: links to the addresses in column E, labelled “Write to surname”.
- In I2 — a link to the website in H2 labelled “Excel help”.
- Text for a text box linked to a cell: in B6 build “Sections: 3”, counting the sections with a formula.
- In B7 count the addresses in the company.com domain (wildcard *).
Solve the tasks in the trainer →
Check yourself
- Which shortcut inserts a hyperlink?
- How do you make a text box show the value of cell B5?
- You embedded a Word document with “Link to file”. What happens if the source changes?