Printing Problems

How to Make One Excel Page Landscape While Others Are Portrait

Maira Mehtab Sep 22, 2026 868 views

Question details

The user wants to know if it is possible to apply different page orientations (landscape and portrait) to individual pages within the same Excel worksheet.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Preparing a multi-page spreadsheet report for printing or PDF export where some wide data requires a landscape view.
Observed behavior: Excel applies the page orientation setting to the entire worksheet's print setup, restricting the user from mixing portrait and landscape pages on a single sheet.

Before you start

Since Excel applies orientation settings to the entire worksheet, identify exactly which sections of your data require a landscape layout before adjusting your workbook structure.

Solution 1Recommended

Separate the Data into Different Worksheets

The most reliable workaround within Excel is to place the landscape-oriented data onto its own separate worksheet.

Excel does not allow a single worksheet to contain both portrait and landscape pages. However, different worksheets within the same workbook can have different print orientations. By separating your data, you can print the entire workbook at once with mixed orientations.

Create a new worksheet

Click the '+' icon at the bottom of the Excel window to add a new worksheet for your landscape data.

Move the wide data

Cut the data that requires a landscape view from your original sheet and paste it into the newly created worksheet.

Change the orientation

Navigate to the 'Page Layout' tab on the ribbon, click 'Orientation', and select 'Landscape'. The original sheet remains in Portrait.

Print the workbook

Hold the Ctrl key and click both worksheet tabs to group them. Go to File > Print, and Excel will print the first sheet in portrait and the second in landscape.

Adjust Print Areas: Make sure to set the Print Area (Page Layout > Print Area > Set Print Area) on both worksheets so that only the necessary data is printed.

Solution 2

Assemble the Final Report in Microsoft Word

If the data must appear sequentially in a single document, copying the tables into a word processor like Word allows for section-by-section orientation changes.

Free Microsoft Office alternative

Create and Print Complex Reports with WPS Office

While mixing orientations in a single spreadsheet is a limitation across all spreadsheet software, WPS Office provides a complete, seamless suite including Spreadsheets, Writer, and a built-in PDF editor to effortlessly format and combine your complex reports.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Spreadsheet: Launch WPS Spreadsheets and open your existing .xlsx workbook to organize your data into separate sheets.
3. Export or Transfer: Use WPS Writer to insert section breaks for mixed layouts, or export separate sheets to PDF and merge them using the built-in WPS PDF tool.

Fully compatible with Microsoft Excel (.xlsx) and Word (.docx) file formats.Easily transfer spreadsheet data to WPS Writer for flexible portrait/landscape page layouts.Built-in PDF editor allows you to combine and arrange pages of different orientations effortlessly.Lightweight, fast, and free to use with an intuitive tabbed interface.

microsoft office alternative - wps office

Frequently Asked Questions

Can I change the print orientation of just a specific range of cells?

No, Excel does not allow you to change the orientation for specific cells or ranges. Print orientation is a page-level setting that applies to the entire worksheet.

How do I print multiple worksheets with different orientations at the same time?

Set the orientation for each worksheet individually. Then, group the worksheets by holding the Ctrl key and clicking the sheet tabs at the bottom. Once grouped, go to File > Print, and Excel will print them sequentially in their respective orientations.

Is it possible to mix orientations by exporting to PDF instead of printing?

Yes. You can save the portrait worksheet as one PDF and the landscape worksheet as another. Afterward, use a PDF editor (like WPS PDF) to merge the two files into a single document containing both portrait and landscape pages.

Why does my landscape data get cut off when printed?

This happens if the printer settings override the spreadsheet layout, or if the columns exceed the landscape page width. Go to View > Page Break Preview to see the print boundaries, and use the 'Fit to One Page' scaling option in the Print menu to scale the data properly.

Document & File Issues