You need to print an Excel workbook where some sheets look best in portrait and others in landscape. Excel’s default print settings apply to the entire workbook, which forces you to print each sheet separately. This happens because page setup options are saved individually for each worksheet. This article explains how to set portrait or landscape orientation on a per-sheet basis within the same file.
Key Takeaways: Setting Individual Sheet Print Orientation
- Page Layout > Orientation: Sets the print direction for the active worksheet without affecting other sheets.
- Page Setup dialog (Page Layout > Dialog Launcher): Provides access to advanced print settings like margins and scaling for a single sheet.
- Print Preview (Ctrl+P): Confirms the orientation for each sheet before sending the entire workbook to the printer.
How Excel Manages Print Settings Per Worksheet
In Excel, page setup properties like orientation, margins, and headers are stored at the worksheet level. This design allows you to customize how each sheet prints. The orientation setting you choose in the Page Layout tab only applies to the sheet you are currently viewing. You must select each sheet individually to configure its print layout. There are no workbook-level defaults for these settings, giving you full control over each page’s format.
Steps to Configure Unique Print Orientations
Follow these steps to set a different orientation for each sheet in your workbook. You must repeat the process for every sheet you want to change.
- Select the first worksheet
Click the sheet tab at the bottom of the Excel window to make it the active sheet. - Open the Page Layout tab
Go to the Page Layout tab on the Excel ribbon. - Choose an orientation
In the Page Setup group, click the Orientation button. Select either Portrait or Landscape from the dropdown menu. - Verify the setting for the sheet
Press Ctrl+P to open the Print Preview pane. Check that the preview shows the correct orientation. - Repeat for other sheets
Click on the next sheet tab, return to the Page Layout tab, and set its orientation. Continue until all sheets are configured.
Using the Page Setup Dialog for More Control
For additional settings like custom scaling or margins, use the full Page Setup dialog.
- Click the Dialog Launcher
On the Page Layout tab, click the small arrow icon in the bottom-right corner of the Page Setup group. - Set orientation on the Page tab
In the dialog box, ensure you are on the Page tab. Select the Portrait or Landscape option button. - Apply and close
Click OK to save the settings and close the dialog. These changes apply only to the active sheet.
Common Mistakes and Limitations
Excel Resets to a Default Orientation
If orientation seems to reset, you may have applied settings to a grouped selection of sheets. Right-click any sheet tab and select Ungroup Sheets. Then, apply the orientation to each sheet individually. Also, check if a macro or template is overriding your page setup.
Print Preview Shows the Wrong Layout
The Print Preview shows settings for the active sheet only. If you see an unexpected orientation, ensure you have selected the correct sheet tab before checking the preview. The preview does not cycle through all sheets automatically.
Cannot Set Orientation for Multiple Sheets at Once
While you can group sheets by holding Ctrl and clicking their tabs, any page setup change will apply to all selected sheets. To have different orientations, you must configure sheets one at a time. There is no built-in feature to batch-assign unique orientations.
Page Layout Tab vs. Page Setup Dialog: Key Differences
| Item | Page Layout Tab (Quick Settings) | Page Setup Dialog (Full Control) |
|---|---|---|
| Access Speed | One click on the ribbon | Requires clicking the dialog launcher |
| Orientation Setting | Direct button for Portrait/Landscape | Option button on the Page tab |
| Additional Settings | Limited to basic size and orientation | Includes scaling, paper size, print quality, margins, header/footer |
| Best For | Quickly toggling orientation only | Fine-tuning all print parameters for a complex sheet |
You can now print a workbook with mixed portrait and landscape pages. Use the Page Layout tab for simple changes and the Page Setup dialog for precise control. Always check Print Preview for each sheet before final printing. For advanced layouts, explore setting different print areas for each sheet using Page Layout > Print Area > Set Print Area.