Skip to content
FileMyLove

Excel to PDF: Missing Rows, Columns and Print Areas

Check saved print areas and hidden rows, columns or sheets before exporting Excel to PDF, then verify the delivery copy.

By FileMyLove2 min read

If Excel shows a complete table but the PDF loses its final rows or rightmost columns, check the saved print area and hidden content before converting again. Repeating the same input may produce the same omission.

How the print area affects output

Microsoft describes Print Area as a saved selection of cells for printing. For example, a table might grow to row 80 while its print area still ends at row 50.

FileMyLove uses the print area it reads and skips hidden sheets, rows and columns. For XLSX with several separate print ranges, it reads the first range. Do not assume it reproduces every multiple-area Excel layout.

Identify the symptom

Symptom Our suggested check
Final rows missing Print-area boundary and hidden rows
Columns missing Selected columns and hidden status
Entire sheet absent Whether the sheet is hidden
Complete but tiny text Table width and print preview

The site lays out tables on A4 and reduces their scale to fit the page width. Smaller text does not restore excluded cells. Reorganize very wide tables in the source first.

Prepare a delivery copy

  1. Keep the original workbook and create an export copy.
  2. Review the sheets, rows and columns the recipient should see. Do not blindly unhide everything.
  3. In Excel, inspect Page Layout → Print Area. Set a new range or use Clear Print Area to remove the old boundary.
  4. Save the workbook, open Convert document, choose PDF and inspect the preview before Save as PDF.
  5. Reopen the PDF and compare headings, first and final records, and totals against the source copy.

For multiple print ranges or complex layouts that must be retained, export from the supporting source application and check the result.

Missing records versus incorrect values

If every row is present but values differ, read about stored Excel formula results. The site does not recalculate formulas. A matching page count alone does not establish correctness.

For exchanging table data instead of printed pages, see multiple Excel sheets to CSV and agree on the format with the recipient first.