How to Keep Excel Font Size Readable When Printing on One Page
Question details
The user needs to fit an entire Excel worksheet onto a single printed page without the text scaling down to an unreadable size.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Preparing to print a large spreadsheet on a single sheet of paper for easier physical review or reporting.
- Observed behavior
- When applying the "Fit Sheet to One Page" setting, Excel automatically scales down the entire worksheet, causing the printed font to become too small and difficult to read.
Before adjusting your print settings, review your worksheet and hide or delete any unnecessary columns or empty rows to minimize the overall data area.
Adjust Margins, Paper Size, and Custom Scaling
Maximize the printable area of your paper layout before applying scaling, which helps preserve a larger, more readable font size.
Because Excel mathematically shrinks your worksheet to fit the physical dimensions of the paper, it is impossible to fit a massive amount of data onto one page while keeping the original 100% font size. However, optimizing your page setup limits how drastically the text is reduced.
Navigate to the File tab and select Print, or press Ctrl + P on your keyboard to open the print preview and settings screen.
If your spreadsheet has many columns, change the orientation from Portrait to Landscape under the settings menu. This utilizes the paper's width better.
Click on the Margins dropdown (usually set to Normal) and select Narrow Margins. This pushes the boundaries closer to the paper's edge, creating more room for your data.
If your printer supports it, change the paper size from Letter/A4 to a larger format like Legal or A3. A larger physical page requires less scaling.
Instead of using the automatic 'Fit Sheet to One Page', click on 'Custom Scaling Options' and manually adjust the "Adjust to % normal size" value until the preview looks readable but still fits effectively.

Optimize Worksheet Layout and Wrap Text
Reduce the physical width of your active data columns so that the automatic scaling is less aggressive.
Print Spreadsheets Perfectly with WPS Spreadsheet
WPS Office offers a highly intuitive Print Preview and Page Layout interface that makes adjusting margins, page orientation, and scaling a breeze. You can easily tweak settings to fit your data to one page while directly monitoring text readability.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet application, and load your Excel document.
- 2. Access Print Preview: Click the 'Print Preview' icon located on the quick access toolbar, or go to Menu > Print > Print Preview.
- 3. Adjust Page Setup Visually: Use the Page Setup button in the preview window to effortlessly toggle Landscape orientation, select narrow margins, and tweak the scaling percentage until the text is perfectly readable.

Frequently Asked Questions
Why does 'Fit Sheet to One Page' make my font so tiny?
When you choose this setting, Excel forcefully shrinks everything in the active print area—including rows, columns, and fonts—proportionally to fit the physical dimensions of your selected paper size. If you have extensive data, the scaling percentage drops significantly, leading to tiny text.
Can I lock the font size while fitting the sheet to one page?
No, Excel cannot lock the exact physical font size while forcing a large document onto a single piece of paper. You must either reduce the amount of data by hiding columns/rows or use a larger paper size to prevent extreme scaling.
Is there a way to fit all columns on one page but let rows span multiple pages?
Yes. In the Print Preview settings under the Scaling dropdown, choose 'Fit All Columns on One Page' instead of 'Fit Sheet on One Page'. This setting keeps your horizontal data readable and neatly formatted while allowing long vertical lists to naturally print across multiple pages.




