Explanation

These tools control which part of the worksheet is printed and how multiple pages are organized.

Key Tools

  • Print Area: Select only the required cells for printing.
  • Page Breaks: Divide a worksheet into separate printed pages.
  • Print Titles: Repeat selected rows or columns on every printed page.

Example

For a 100-student marks sheet, set the heading row as a Print Title so it appears on every page.

Practice

Create a multi-page report and:

  1. Set a Print Area.
  2. Insert a Page Break.
  3. Repeat the header row on every page.
PreviousNext