Scale a worksheet to print in a different font size

When you print an Excel worksheet, if the printed font size is not what you expected, you can scale the worksheet for print by increasing or decreasing its font size.

  1. Open the worksheet that you want to print and click File > Print.

  2. Under Settings, click Custom Scaling > Custom Scaling Options.

    custom Scaling print option

  3. Click Page and in the Adjust to box, pick a percentage by which you want to increase or decrease the font size.

  4. Review your changes in Print Preview and if you want a different font size, repeat the steps.

Tip: Before you click Print, check the paper size setting in the printer properties, and also make sure the printer actually has paper of that size. If the paper size setting is different from the paper size in your printer, Excel adjusts the printout to fit the paper size in the printer and the printed worksheet might not match your Print Preview.

In Print Preview, if the worksheet appears compacted to a single page, check if a scaling option like Fit Sheet on One Page is applied. To remove a scaling option, click the scaling option and pick No Scaling.

Print without any scaling

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!