Print Excel Worksheets in Mixed Portrait and Landscape Orientation
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.

- 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.
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.
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.
Click the worksheet tab that should print in portrait orientation.
On the Page Layout tab, select Orientation > Portrait.
Click the worksheet tab that needs a wider printed layout.
Go to Page Layout > Orientation > Landscape for that worksheet.
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.

Add page breaks and page numbers before printing
Use this method when the worksheets must print in a defined order with page numbering in the header or footer.
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. Open the workbook in WPS Spreadsheets: Open the Excel workbook, then click the worksheet tab that should use portrait orientation.
- 2. Set the first worksheet orientation: Select Page Layout > Orientation > Portrait.
- 3. Set the second worksheet orientation: Click the worksheet tab that needs a horizontal layout, then choose Page Layout > Orientation > Landscape.
- 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. 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.

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.




