Printing Problems

Print Excel Worksheets in Mixed Portrait and Landscape Orientation

Ayan MasoodAyan Masood Nov 12, 2026 868 views

Question details

The user needs to print multiple Excel worksheets together while keeping one worksheet in portrait orientation and another in landscape orientation, with consecutive page numbers.

Print Excel Worksheets in Mixed Portrait and Landscape Orientation
Product
Microsoft Excel worksheets
Device & OS
not provided
Scenario
Printing a workbook containing worksheets with different page layout requirements.
Observed behavior
The printout uses an incorrect orientation instead of preserving the orientation set for each worksheet.
Before you start

Set up each worksheet individually before selecting multiple sheets for printing. Check Print Preview to confirm that the print area, page breaks, and orientation are correct for every worksheet.

Solution 1Recommended

Set orientation and print settings for each worksheet separately

Use this method when each worksheet needs its own portrait or landscape layout in the same workbook.

Page orientation is a worksheet-level setting. Configure the layout on each sheet before printing the workbook or selected worksheets together.

1
Select the first worksheet

Click the worksheet tab that should print in portrait orientation.

2
Choose portrait orientation

On the Page Layout tab, select Orientation > Portrait.

3
Select the other worksheet

Click the worksheet tab that needs a wider printed layout.

4
Choose landscape orientation

Go to Page Layout > Orientation > Landscape for that worksheet.

5
Set the print area and preview

For each worksheet, select the required cells and choose Page Layout > Print Area > Set Print Area. Then select File > Print and review the preview before printing the selected sheets or the entire workbook.

Set orientation and print settings for each worksheet separately
Orientation is saved by worksheet: Do not set one orientation while multiple worksheet tabs are grouped, because the setting may be applied to every selected sheet.
Print worksheets with separate page layouts

Print Mixed Portrait and Landscape Worksheets in WPS Spreadsheets

WPS Spreadsheets lets you set portrait or landscape orientation on each worksheet, define print areas and page breaks, and add page numbers before reviewing the final output in Print Preview.

  1. 1. Open the workbook in WPS Spreadsheets: Open the Excel workbook, then click the worksheet tab that should use portrait orientation.
  2. 2. Set the first worksheet orientation: Select Page Layout > Orientation > Portrait.
  3. 3. Set the second worksheet orientation: Click the worksheet tab that needs a horizontal layout, then choose Page Layout > Orientation > Landscape.
  4. 4. Configure printing details: Use Page Layout > Print Area > Set Print Area and Page Layout > Breaks to define the printed range and page divisions for each worksheet.
  5. 5. Add numbering and print: Choose Insert > Header & Footer to add page numbers, then open File > Print to review every page in Print Preview and send the worksheets to the printer.
Set a different page orientation for each worksheet before printing.Use Print Area and Page Break Preview to control exactly what appears on each page.Add page numbers through worksheet headers and footers.Open and print Microsoft Excel .xlsx and .xls workbook formats with compatible layout tools.
microsoft office alternative - wps office

Frequently Asked Questions

Can different worksheets in one Excel workbook have different print orientations?

Yes. Click each worksheet tab individually and use Page Layout > Orientation to choose Portrait or Landscape. The setting is stored for that worksheet.

Why did all my worksheets change to landscape orientation?

The worksheet tabs were likely grouped when you changed the setting. Click a single sheet tab, or right-click a grouped tab and choose Ungroup Sheets, then set orientation on each worksheet separately.

How do I set a print area for each worksheet?

Select the cells to print on a worksheet, then choose Page Layout > Print Area > Set Print Area. Repeat this on each worksheet that needs a different range.

Where can I add page numbers to a worksheet printout?

Use Insert > Header & Footer, click the header or footer section, and insert the page number field from the Header & Footer tools.

What should I do if mixed orientations are wrong in the combined print job?

Open File > Print and verify each preview page. If the application does not preserve the saved layouts when printing sheets together, print each worksheet separately after confirming its orientation and page setup.