Excel "scale to fit" on print preview is broken and over-shrinking my document

Question

This issue with Excel has almost driven me crazy.
I turn on "shrink to fit" (1x1), then it makes the print size in print preview so small it wants to print 1/3 of blank space all around the content.
All the help available seems to be written by brain-dead robots that assumes we are even more brain-dead.
Here is what I found as a "fix":

• change print range, by making it one column smaller. do print preview and ensure it has fixed the size,
• then change the range to your proper desired range and it should be ok.

Disclaimer: this worked today; tomorrow it might go whack again.
Appeal to MS: please fix your program (and stop all your agents given us stupid, obvious nonsense as fixes)

Answer 1

Hello @Rob Matthews

From what you described, you are using “Fit to 1 page wide by 1 page tall” and the preview shows the content very small with large blank margins.

I will walk through this together with you. There are three points in your situation:

• You want the worksheet to fit neatly on one page without excessive shrinking.
• The preview is showing extra blank space around the content.
• You found that adjusting the print area temporarily helps, but it does not always stay consistent.

At first, I will share a few additional checks may help identify what is affecting the page scaling:

1. Verify the Print Area

• Open the "Page Layout" tab.
• Select "Print Area" > "Clear Print Area".
• Re-select only the range that should be printed, then choose "Print Area" >" Set Print Area".
• Open "File" > "Print" and check whether the preview changes.

2. Check for manual page breaks

• Select the "View" tab.
• Choose "Page Break Preview".
• Look for any blue page-break lines that may be forcing Excel to scale the sheet unexpectedly.
• If needed, go to "Page Layout" > "Breaks" > "Reset All Page Breaks".

Insert, move, or delete page breaks in a worksheet

3/ Review Scaling settings

• Go to the "Page Layout" tab.
• In the Scale to Fit section, try setting:
• Width = 1 page
• Height = Automatic
• Then check the print preview again.

Scale a worksheet

4/ Check for unintended used rows or columns

• Press Ctrl + End (or Fn + Ctrl + Right Arrow / Down Arrow on some Mac keyboards) to see the last cell Excel considers in use.

If this location is far beyond the actual data range, extra rows, columns, or formatting may be influencing the print layout.

The workaround you documented is appreciated, as it may help others experiencing the same behavior.

Looking forward to hearing from you!

---

If the answer is helpful, please click "Yes". If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread