Explanation

These Insert tools help add additional information, navigation and professional elements to an Excel worksheet.

Topics Covered

  • Hyperlink
  • Text Box
  • Header & Footer
  • Symbols

Key Concepts

Hyperlink: Creates a clickable link to a website, file, email address or another location.

Text Box: Allows you to place text independently on the worksheet.

Header & Footer: Adds information such as report title, company name, date or page number to printed pages.

Symbols: Allows you to insert special characters and symbols.

Example

A business report could include:

Header: ABC Company — Monthly Sales Report

Text Box: Prepared by Sales Department

Hyperlink: Company Website

Footer: Page Number

Practice

Create a one-page Business Sales Report and add:

  • One hyperlink
  • One text box
  • Header
  • Footer
  • One suitable symbol
PreviousNext