Scale a worksheet for printing

Got it! To scale a worksheet for printing in Excel — that is, adjust the size so it fits better on the printed page — here’s how you do it:

How to Scale a Worksheet for Printing

Method 1: Using Print Settings (Quick & Visual)

1. Go to File → Print (or press Ctrl + P).
2. Under Settings, find the Scaling dropdown (usually defaults to No Scaling).
3. Choose one of these options:
   • Fit Sheet on One Page — shrinks the whole sheet to fit on a single page.
   • Fit All Columns on One Page — fits all columns on one page but allows rows to spill to multiple pages.
   • Fit All Rows on One Page — fits all rows on one page but allows columns to spill.
4. Preview the results on the right. If the text looks too small or large, try different options.

Method 2: Using the Page Layout Tab (More precise)

1. Click the Page Layout tab on the Ribbon.
2. In the Scale to Fit group, adjust:
   • Width: Set to number of pages wide (e.g., 1 page).
   • Height: Set to number of pages tall (e.g., 1 page).
   • Scale: Adjust percentage manually to shrink or enlarge the printout.
3. Excel will automatically apply this scaling when printing.

Tips:

• Setting Width and Height to 1 forces the entire sheet to print on a single page (can make fonts very small).
• You can manually adjust the Scale % if you want a custom size.
• Changing page Orientation to Landscape (Page Layout → Orientation) helps fit wider sheets.