PDF Conversion Issues

How to Keep Excel Landscape Orientation When Converting to PDF

Nimra MalikNimra Malik Oct 28, 2026 871 views

Question details

The user needs to maintain the landscape page orientation of an Excel spreadsheet when saving, converting, or uploading it as a PDF document.

How to Keep Excel Landscape Orientation When Converting to PDF
Product
Excel / PDF Editor
Device & OS
not provided
Scenario
Converting or uploading an Excel spreadsheet that was originally designed in landscape format into a PDF file.
Observed behavior
The resulting PDF file incorrectly displays the spreadsheet in portrait orientation, often cutting off columns or squishing data instead of preserving the original landscape layout.
Before you start

Verify that your original Excel spreadsheet explicitly has its page layout set to Landscape orientation and that your print area includes all the data you wish to convert.

Solution 1Recommended

Configure Page Setup Settings Before PDF Conversion

The most effective way to ensure a landscape PDF is to force the spreadsheet application's print and export settings to landscape before saving as a PDF.

PDF conversion tools often rely on the default printer settings of your operating system. By explicitly defining the page setup within your spreadsheet software, you override the default portrait mode.

1
Open Page Layout Settings

Navigate to the 'Page Layout' tab on the ribbon menu at the top of your Excel workbook.

2
Set Orientation to Landscape

Click on the 'Orientation' button and select 'Landscape' from the dropdown menu to apply this layout to the active sheet.

3
Adjust Print Scaling

Click on 'Print Titles' or the small arrow in the bottom-right corner of the Page Setup group. Under the 'Page' tab, select 'Fit to' and set it to '1 page(s) wide' to ensure columns don't spill over to the next page.

4
Export as PDF

Go to 'File' > 'Export' > 'Create PDF/XPS Document', or 'File' > 'Save As' and choose PDF from the format dropdown. The file will now export in the correct landscape orientation.

Configure Page Setup Settings Before PDF Conversion
Worksheet Specific Settings: Remember that page orientation is specific to each worksheet. If you are converting a whole workbook, you must apply the landscape setting to each individual sheet before exporting.
Effortless PDF Conversion

Use WPS Office to Convert Spreadsheets to Landscape PDFs Accurately

WPS Office provides a highly reliable 'Export to PDF' feature that perfectly retains your spreadsheet's original layout, orientation, and scaling without requiring complex print settings adjustments.

  1. 1. Open the File: Launch WPS Spreadsheets and open your target Excel file.
  2. 2. Verify Page Layout: Navigate to the 'Page Layout' tab and verify that 'Orientation' is set to Landscape.
  3. 3. Export to PDF: Click the 'Menu' button in the top left corner, select 'Export to PDF', configure your save location, and click 'Export'.
Retains original landscape and portrait formatting perfectly during PDF conversionComplete format compatibility with Microsoft Excel (.xlsx, .xls) filesBuilt-in, one-click Export to PDF tool without needing third-party pluginsClean interface makes adjusting page layouts fast and intuitive
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel file change to portrait when saving as PDF?

This typically occurs because the PDF conversion relies on your computer's default printer settings, which usually default to portrait mode. If the orientation is not explicitly locked as landscape in the spreadsheet's Page Setup settings, the converter reverts to the default portrait layout.

Can I change the orientation of just one sheet in a multi-sheet Excel file before converting?

Yes, page orientation in spreadsheet software is applied on a sheet-by-sheet basis. You can select a specific worksheet, go to the Page Layout tab, and set it to landscape, leaving the other sheets in portrait. When exporting the entire workbook to PDF, each sheet will retain its specific orientation.

How do I ensure all my landscape columns fit onto one PDF page?

Before converting the file to PDF, navigate to the Page Layout tab and open the detailed Page Setup dialog box. Under the Scaling section, select the 'Fit to' option and set it to '1 page(s) wide by [blank] tall'. This scales your columns perfectly to the width of a landscape PDF page.