How to Set a Custom Print Scale Percentage in Excel

Tap each step to see how to set a custom print scale percentage in Excel.

  1. Open the "Page Layout" tab

    Click the "Page Layout" tab on the ribbon.

  2. Find the scale input in the "Scale to Fit" group

    Look for the percentage box labeled "Scale" within the "Scale to Fit" group.

  3. Type in the exact percentage you want

    Enter a number directly, such as 90% or 120%.

  4. Check the result with print preview

    Press Ctrl + P to preview how the page will print at that scale before you actually print it.

  5. Why it helps

    Instead of letting an automatic option like "Fit to one page" decide the size for you, this lets you enlarge or shrink the printed output to an exact percentage you choose.

This is different from "Fit to page"

Excel's "Fit to" option automatically calculates whatever scale is needed to squeeze content onto a set number of pages, which can shrink text to an awkward, unpredictable size. Typing an exact percentage instead gives you full control, which matters when you need consistent, readable text size across multiple printed reports.

The scale applies uniformly to both dimensions

Entering a percentage in this box scales the printed page proportionally β€” both width and height change by the same amount β€” so the layout keeps its original aspect ratio. If you need to change only how many columns fit per page without affecting row height, adjusting page margins or column widths directly is usually a better fit than the scale percentage.

Frequently Asked Questions

What percentage should I use to make a printout roughly half its normal size?

A scale of around 50% will make the printed content appear roughly half its original dimensions, though remember scaling applies to width and height together, so the printed area shrinks more than half in total size.

Does changing the scale percentage affect what appears on screen while editing?

No. The scale percentage only affects how the worksheet is printed; it has no effect on the zoom level or appearance of the spreadsheet while you're working in it.