Printing Problems

How to Keep Excel Font Size Readable When Printing on One Page

Bushra ParveenBushra Parveen Oct 29, 2026 872 views

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.

How to Keep Excel Font Size Readable When Printing on One Page
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 you start

Before adjusting your print settings, review your worksheet and hide or delete any unnecessary columns or empty rows to minimize the overall data area.

Solution 1Recommended

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.

1
Open Print Preview

Navigate to the File tab and select Print, or press Ctrl + P on your keyboard to open the print preview and settings screen.

2
Change Paper Orientation

If your spreadsheet has many columns, change the orientation from Portrait to Landscape under the settings menu. This utilizes the paper's width better.

3
Apply Narrow Margins

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.

4
Select a Larger Paper Size

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.

5
Adjust Custom 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.

Adjust Margins, Paper Size, and Custom Scaling
Physical Limitations: Excel cannot fit an infinitely large worksheet onto one page while preserving the original physical font size. If adjusting margins and orientation isn't enough, you may need to print across multiple pages.
Seamless Spreadsheet Printing

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. 1. Open your file in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet application, and load your Excel document.
  2. 2. Access Print Preview: Click the 'Print Preview' icon located on the quick access toolbar, or go to Menu > Print > Print Preview.
  3. 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.
Fully compatible with Microsoft Excel (.xlsx, .xls) files.Visual Print Preview with easy drag-and-drop margin adjustments.Built-in Page Layout view to precisely control scaling and readability.Free and lightweight suite with a familiar user interface.
QA img-9

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.