Printing Problems

Fix Excel Printing an Old Page Break or Layout

Steve KSteve K Nov 18, 2026 869 views

Question details

The user needs Excel to print the current page breaks and layout shown in Print Preview.

Fix Excel Printing an Old Page Break or Layout
Product
Microsoft Excel
Device & OS
not provided
Scenario
Printing a worksheet after changing its page breaks or page setup.
Observed behavior
Print Preview shows the current layout, but the printed page appears to use an older layout.
Before you start

Identify the worksheet and printer you intend to use, and note the desired paper size and orientation. Save the workbook before testing the print settings.

Solution 1Recommended

Reset the worksheet print area and page breaks

Use this when the worksheet may still contain an old print area or manual page breaks.

1
Select the worksheet

Click the worksheet tab, then open File > Print. Select the intended printer and choose Print Active Sheets under Settings.

2
Clear and set the print area

Return to the worksheet and choose Page Layout > Print Area > Clear Print Area. If you need to print a specific range, select it and choose Page Layout > Print Area > Set Print Area.

3
Reset manual page breaks

Choose Page Layout > Breaks > Reset All Page Breaks. This removes manual page breaks so you can set them again if needed.

4
Review and print

Open View > Page Break Preview to inspect the page boundaries. Then open File > Print, check the paper size, orientation, and scaling, and print a test page.

Reset the worksheet print area and page breaks
Free Microsoft Office alternative

Review Spreadsheet Print Layouts with WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and review print settings in WPS Spreadsheets as you move between office suites.

Review spreadsheet page layout and print settingsCompatible with Microsoft Excel XLS and XLSX filesFamiliar interface for working with spreadsheetsFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel print a different layout from Print Preview?

A queued job, printer-specific settings, or a driver issue may be responsible. Check the selected printer and its properties under File > Print, then compare the result with a PDF or another printer.

How do I remove old manual page breaks in Excel?

Select the worksheet and choose Page Layout > Breaks > Reset All Page Breaks. Use View > Page Break Preview to check the resulting page boundaries.

How do I print only the cells I need?

Select the cells, then choose Page Layout > Print Area > Set Print Area. Check the result under File > Print before printing.

What should I do if the PDF looks correct but the paper printout does not?

Open File > Print, select the physical printer, and check Printer Properties for paper size, orientation, and scaling. If those settings are correct, update or reinstall the printer driver and test again.