SpreadsheetFitWhy Excel Prints So Small (and How to Fix It)
By Yasir · Updated 9 November 2026
Short answerExcel prints small when it has to squeeze too many columns or rows onto one page, often because Fit Sheet on One Page is on or the print area includes empty cells far to the right. Set Scale to Fit to Width: 1 page, Height: Automatic, use Landscape, and remove unused columns. SpreadsheetFit shows the text size before you print and lets you set the smallest size you will accept.
Why this happens
- Fit Sheet on One Page shrinks a long sheet until every row fits on a single page.
- Formatting or a stray value far away (for example in column Z) makes Excel think the sheet is much bigger.
- The Scale box was set to a low percentage, such as 40%, and stayed that way.
- The sheet has many wide columns but is printed in Portrait.
- The paper size in Excel is larger than the paper in the printer.
Fix it in Excel
- Press Ctrl+End. If Excel jumps far beyond your data, select the empty columns and rows, right-click and choose Delete, then save.
- Go to Page Layout → Scale to Fit. Set Width to 1 page and Height to Automatic, so long sheets flow onto more pages instead of shrinking.
- Click Page Layout → Orientation → Landscape for wide sheets.
- Click Page Layout → Margins → Narrow to gain a little space.
- Check Page Layout → Size matches the paper in your printer.
- Press Ctrl+P and zoom the preview to check that the text is readable.
Fix it with SpreadsheetFit
- Open SpreadsheetFit and choose your file.
- Look at the text size shown above the preview. It tells you how big the printed text will be.
- Use Smallest text to choose a minimum, from 6 pt to 10 pt, or leave it on Auto (recommended).
- Set Orientation to Auto or Landscape, and try Narrow margins.
- If you only need part of the sheet, choose Customized and enter the columns and rows. Then download the PDF.
Skip the manual steps. Fit any spreadsheet to the page and get a clean PDF or corrected Excel file in one tap.
Try SpreadsheetFitCommon questions
Why does Fit Sheet on One Page make text unreadable?
It fits every row and column on one page, so a long sheet is shrunk a lot. Fitting only the width keeps text larger.
What is a readable size for printed tables?
For most people about 8 pt and above is comfortable; below 7 pt becomes hard to read.
Can I make a small table bigger instead?
Yes. In SpreadsheetFit, Enlarge to fill page makes a small table fill the paper.