Excel Prints Two Pages Instead of Three with Fit to Page Scaling
Question details
The user wants an Excel worksheet to print one page wide and three pages tall, but the printout contains only two pages vertically.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Printing a worksheet with Fit to scaling set to 1 page wide and 3 pages tall.
- Observed behavior
- Excel prints the worksheet on one page wide and two pages tall despite the three-page height setting.
Select the worksheet you want to print and open File > Print to check the preview and selected printer. Confirm the intended paper size and whether you need exactly three pages or simply want to keep the worksheet within three pages vertically.
Check Fit to scaling and the worksheet print area
Use this first to confirm the scaling settings and determine whether two pages already contain all the intended data.
Fit to sets page-count limits; it does not guarantee that Excel will produce exactly that many pages. A setting of 1 page wide by 3 pages tall can produce only two vertical pages if the worksheet fits within that limit.
Open Page Layout > Page Setup. On Windows, use the small dialog launcher in the Page Setup group. On the Page tab, select Fit to and enter 1 page wide by 3 pages tall, then click OK.
Open File > Print and check that all required rows and columns appear in the preview. If data is missing because of an old print area, choose Page Layout > Print Area > Clear Print Area, select the required cells, and choose Page Layout > Print Area > Set Print Area.
In Page Layout, review Size, Orientation, and Margins. Confirm that the paper size matches the paper selected for your printer, then return to File > Print to review the resulting page count.
If your main goal is to keep every page one page wide, return to Page Setup > Page and leave the tall field blank where supported. Alternatively, set Page Layout > Scale to Fit > Width to 1 page and Height to Automatic. Check File > Print again.
Use manual page breaks when you need exactly three vertical pages
Use this when specific row groups must appear on three separate printed pages rather than merely fit within a three-page limit.
Review and Print Excel Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative for opening Excel workbooks and reviewing worksheet print layouts. Its familiar interface and Excel format compatibility make migration straightforward, though it does not repair Microsoft Excel's scaling behavior.
Frequently Asked Questions
Why does Excel print only two pages when I set the height to three pages?
Fit to treats the specified page count as a limit rather than a requirement to fill every page. Open File > Print and check whether all required data is present. If it is, a two-page result can be normal.
How do I keep the worksheet one page wide without limiting its height?
Choose Page Layout > Scale to Fit, set Width to 1 page, and set Height to Automatic. In versions that support it, you can also open Page Setup > Page, select Fit to, enter 1 for width, and leave the tall field blank.
Why are my manual page breaks being ignored?
Fit to scaling can override manual page breaks. Open Page Layout > Page Setup > Page, select Adjust to percentage scaling, and then use Page Layout > Breaks > Insert Page Break to control where pages begin.
What should I check if rows are missing from the print preview?
Check Page Layout > Print Area first. Clear an outdated print area and set a new one around the required cells. In File > Print, also confirm that you are printing the intended sheet rather than only a selected range.
Will WPS Office fix the scaling settings inside Microsoft Excel?
No. WPS Office is a separate Office alternative, not a repair tool for Excel. You can open the workbook in WPS Spreadsheet and review its print layout independently; check the preview because page boundaries can differ between applications.
