Explanation

Scale to Fit helps adjust a worksheet so that it fits properly on the printed pages.

Key Tools

  • Width: Fit the worksheet to a specific number of pages wide.
  • Height: Fit the worksheet to a specific number of pages tall.
  • Scale: Adjust the worksheet’s print size.
  • Fit Sheet on One Page: Shrink the entire worksheet to one page.

Example

If a report prints on two pages horizontally, set:

Width → 1 Page

This keeps all columns on one page.

Practice

Take a wide Sales Report and configure it to Fit Sheet on One Page.

PreviousNext