PDF Conversion Issues

How to Make Acrobat Respect Excel Page Breaks When Creating PDFs

Steve KSteve K Oct 28, 2026 869 views

Question details

The user needs the Adobe Acrobat Excel add-in to maintain manually inserted page breaks when converting spreadsheets to PDF documents.

How to Make Acrobat Respect Excel Page Breaks When Creating PDFs
Product
Microsoft Excel, Adobe Acrobat
Device & OS
not provided
Scenario
Converting a formatted Excel workbook into a PDF file using the Acrobat conversion add-in.
Observed behavior
Acrobat ignores manual page breaks when a Fit scaling option is selected, and page sizes scale unexpectedly based on Excel paper settings.
Before you start

Verify that your manual page breaks are correctly placed by switching to Page Break Preview in Excel before attempting the PDF conversion.

Solution 1Recommended

Change Acrobat Scaling to Actual Size

Prevent the Acrobat add-in from overriding your Excel layout by selecting Actual Size instead of Fit settings.

When using the 'Save as Adobe PDF' feature in Acrobat Pro DC's Excel add-in, selecting any 'Fit' setting will cause the converter to ignore manual page breaks. Switching to 'Actual Size' forces the add-in to honor your Excel document layout.

1
Open Acrobat Preferences in Excel

Navigate to the Acrobat tab on the Excel ribbon and click on 'Preferences' or 'Conversion Settings'.

2
Adjust Page Scaling

Locate the page scaling section and change the active setting from 'Fit to Page' (or similar Fit options) to 'Actual Size'.

3
Convert to PDF

Click 'OK' to save your preferences, then click 'Create PDF' or use 'File > Save as Adobe PDF' to generate your file with correct breaks.

Change Acrobat Scaling to Actual Size
Scaling Size Bug Note: If you have Excel's page setup reduction applied (e.g., printed at 90%), using 'Actual Size' may result in an oversized PDF page dimension. The recipient may need to select 'Fit to Page' when printing the resulting PDF.
Built-in PDF Exporter

Export Spreadsheets to PDF Seamlessly with WPS Office

Avoid third-party add-in glitches by using WPS Office. Its built-in PDF exporter accurately preserves your manual page breaks, print areas, and scaling options without requiring external Adobe tools.

  1. 1. Open your file in WPS: Launch WPS Office and open your existing Microsoft Excel workbook.
  2. 2. Check Page Breaks: Navigate to the View tab and select Page Break Preview to ensure your manual layout is correct.
  3. 3. Export to PDF: Click the Menu button, select 'Export to PDF', configure your desired export range, and click 'Export'.
Native Export to PDF tool requires no extra add-insAccurately respects manual page breaks and print areasHighly compatible with Microsoft Excel (.xlsx) formatsLightweight and completely free to use
microsoft office alternative - wps office

Frequently Asked Questions

Why is my PDF page count different from my Excel print preview?

This happens when your PDF converter's scaling settings override Excel's page breaks. Using 'Fit' options instead of 'Actual Size' forces the converter to repaginate the document to fit the target paper size.

Does Microsoft's built-in 'Save as PDF' respect page breaks?

Yes, Microsoft Excel's native 'Save as PDF' function and standard PDF printers generally respect manually inserted page breaks out-of-the-box, avoiding the issues present in specific Adobe Acrobat add-in configurations.

How do I fix oversized PDF outputs when using 'Actual Size' in Acrobat?

Oversized PDFs can occur due to a known bug if Excel's reduction setting is applied (like 90%). To handle this, you or the recipient must choose 'Fit to Page' in your PDF reader's print dialogue when printing the physical document.