Excel to PDF: Control Worksheets, Scaling, and Page Layout

Start with the worksheet selection

Excel to PDF accepts XLSX and legacy XLS workbooks. For XLSX, the workspace inspects worksheet names, hidden state, dimensions, and a small cell sample. Select the visible worksheets you intend to publish. Hidden sheets stay excluded unless you enable “Include hidden worksheets” and select them.

Legacy XLS files use their saved print settings. Save an XLS workbook as XLSX first when you need PDF Logic’s worksheet selection and layout overrides.

Choose between printed pages and one continuous page

Printed pages uses the workbook’s saved setup or your overrides for paper size, orientation, scaling, margins, and gridlines. Available paper overrides are A4, A3, Letter, and Legal. Scaling can preserve the saved value, fit all columns to the page width, fit the whole sheet on one page, or use actual size.

One continuous page per sheet creates one large PDF page for each selected worksheet. In this mode, saved paper sizes and print areas are ignored. It can be useful for on-screen inspection, but a wide or long sheet may be hard to read or print.

Generate, preview, then adjust

1. Choose one workbook, or use Batch for up to 10 workbooks.
2. For a single XLSX, inspect the worksheet sample and select the worksheets to export.
3. Choose Printed pages or One continuous page per sheet. For printed pages, start with saved workbook settings unless a known recipient requirement calls for an override.
4. Generate the PDF and use the PDF preview. Check every selected worksheet, page boundary, repeated heading, clipped column, gridline choice, and page orientation.
5. Adjust settings and generate again when needed. Download only the reviewed result. Batch converts all visible worksheets and provides individual downloads or a ZIP.

Illustrative layout check

This example is illustrative; no output measurements are claimed. Imagine a worksheet with 12 columns and 80 rows. “Fit all columns to page width” can keep the 12 columns together while allowing several pages vertically. “Fit sheet on one printed page” can shrink both dimensions until small text becomes difficult to read. Compare both previews at the size your recipient will use.

Microsoft documents that worksheet pagination depends on paper size, margins, scale, and page breaks in its page-break guidance. Its fit-to-one-page guidance also notes that scaling shrinks worksheet content. Those are useful reasons to inspect the generated PDF rather than treating “fit” as a readability guarantee.

What to verify in the PDF

• All intended worksheets are present and hidden worksheets are handled deliberately.
• Headers, footers, print areas, formulas as displayed values, charts, and images appear where expected.
• Small numbers remain legible and columns are not clipped.
• Page count and paper size match the destination’s requirements.