Fix Excel for Mac Restoring Page Breaks When Saving as PDF
Question details
The user needs to maintain their manually adjusted page breaks when exporting an Excel workbook to a PDF file.
- Product
- Excel for Mac
- Device & OS
- Mac
- Scenario
- Exporting a custom formatted worksheet to PDF format and wanting to preserve the exact page layout.
- Observed behavior
- Manually adjusted page breaks in Page Break Preview revert to their automatic default positions when the workbook is saved directly using the Save As PDF function.
Verify that your manual page breaks are correctly positioned in the Page Break Preview mode and that your printer settings match your desired output size.
Use the macOS Print to PDF Function
Bypass Excel's built-in PDF export tool by using the native macOS print dialog, which reliably preserves your manual page break adjustments.
This method acts as a reliable workaround for the known bug in Office 365 for Mac where the 'Save As' engine recalculates and overrides custom print areas and page breaks.
Navigate to the top menu bar and click on 'File', then select 'Print' instead of choosing the 'Save As' option.
In the bottom-left corner of the Print dialog box, locate and click on the 'PDF' dropdown menu.
Select 'Save as PDF' from the dropdown list. Choose your desired destination folder, enter a file name, and click 'Save' to export your document with the correct layout.
Export Spreadsheets to PDF Seamlessly with WPS Office
If you are tired of formatting bugs and layout glitches in Microsoft Excel for Mac, switch to WPS Office. It provides a highly compatible and lightweight spreadsheet solution that natively retains your manual page breaks and print areas when exporting to PDF, requiring no extra workarounds.
- 1. Download and Install: Visit the official WPS Office website to download the free Mac version and install it on your device.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheet and open your existing .xlsx file. Your manual page breaks will be preserved.
- 3. Export to PDF: Click 'Menu', select 'Export to PDF', and save your document directly with perfect layout accuracy.
Frequently Asked Questions
Why does Excel for Mac ignore my manual page breaks when saving as PDF?
This is a known formatting issue in Office 365 for Mac. The native 'Save As PDF' engine often recalculates the print area based on default margins, overriding the manual adjustments made in Page Break Preview. Using the system's Print dialog bypasses this bug.
Can I adjust page breaks directly in the Mac Print dialog?
No, you cannot drag or manually adjust page breaks within the Print dialog. However, you can use scaling options like 'Fit to 1 Page' in the layout settings to force your content to fit before saving it as a PDF.
Will this print workaround reduce the quality of my exported PDF?
No, the macOS native Print to PDF engine generates high-quality vector PDFs. Your text, tables, and charts will remain sharp and fully searchable, just as they would if you used the built-in Save As feature.
Does WPS Office for Mac suffer from the same PDF page break bug?
No, WPS Office utilizes an independent, highly optimized PDF export engine that accurately respects your customized page layout and manual page breaks natively, eliminating the need for printing workarounds.
