Answers
Short answer: When Fit to One Page appears to be ignored, Excel is almost certainly obeying it — for a sheet that is bigger than you think. Four things stretch the sheet behind your back: leftover manual page breaks, a print area set to the wrong range, a used range that extends past your data, and a paper-size mismatch between Excel and the printer. Clear all four and scaling starts behaving. If the setting genuinely applies and the result is unreadable, that is not a bug either — it is what fitting a wide sheet onto one page looks like.
1. Reset the page breaks. View → Page Break Preview. Solid blue lines are manual breaks you or someone else inserted; they override scaling. Page Layout → Breaks → Reset All Page Breaks removes them.
2. Clear the print area. Page Layout → Print Area → Clear Print Area. A print area from an earlier version of the sheet can cover a different range than the one you are looking at, so “one page” is being applied to something else.
3. Find the real end of the sheet. Press Ctrl + End. If the cursor lands far past your data, the used range has been stretched by formatting or cleared cells, and Excel is trying to fit that whole region. Delete the empty rows and columns properly (right-click → Delete, not Clear Contents), then save, close and reopen — the used range only recalculates on reopen.
4. Check the scaling boxes themselves. In Page Layout → Scale to Fit, “Fit Sheet on One Page” forces width and height. Set Width: 1 page and leave Height: Automatic unless you truly want everything on one sheet of paper. Also confirm the Scale box is not sitting at a fixed percentage — setting a scale value silently switches the fit boxes off.
5. Confirm the paper size. If Excel says A4 and the printer says Letter, the usable width changes and the fit lands differently. File → Options → Advanced has a “scale content for A4 or 8.5x11 inch paper sizes” option that quietly rewrites this.
Fit-to-width does what it says: it compresses the sheet until the columns cross the paper. On a genuinely wide table, that means text below reading size. Past roughly fifteen columns, one page is the wrong goal — a multi-page layout with the header row repeated beats a page nobody can read.
The alternative is a renderer that measures each column’s real width and, when the table cannot be readable at full width, slices it across pages with the label column repeated instead of shrinking everything. CrazySmartPDF does that, keeps every row whole across page breaks, and flags any page that still came out blank or clipped so you can look at it. Windows with Excel 2016+, free on your own files. See how it works, or read the settings-first version of this.
Why does Excel ignore my Fit to One Page setting? It usually is not ignoring it. Manual page breaks and a stale print area both override or redirect the scaling, and a stretched used range makes the sheet larger than the data you can see. Reset the breaks, clear the print area and check Ctrl + End.
Why did setting a scale percentage turn off fit-to-page? They are the same control. Typing a percentage into the Scale box switches Excel from “fit to” mode to “adjust to” mode. Only one can be active.
Fit to one page works but the text is unreadable. What now? Set width to one page and leave the height automatic, so Excel compresses across only and adds pages downward. If the table is wide enough that even that is unreadable, use repeated header rows across multiple pages, or a converter that slices the width readably.
Does clearing the print area lose anything? It only removes the restriction on what prints. Nothing in the sheet changes. Do check afterwards that the export now contains everything you expect — a stale print area can have been hiding real data for months.
