PlayInfoBox

Home /Utilities /How to Set a Different Print Orientation for Each Sheet in Excel

How to Set a Different Print Orientation for Each Sheet in Excel

Tap a step to see how to set print orientation individually for a sheet.

  1. Select the sheet to set

    Go to the sheet whose print orientation you want to set individually.

  2. Open the "Page Layout" tab

    Click the "Page Layout" tab on the ribbon.

  3. Click "Orientation"

    In the "Page Setup" group, click "Orientation."

  4. Choose Portrait or Landscape

    Select "Portrait" or "Landscape" from the dropdown β€” this applies only to the sheet you currently have selected.

  5. Why is this useful?

    When a summary sheet should print in portrait but a wide data sheet in the same file needs landscape, you can set each sheet's orientation individually.

Match the Orientation to the Table

A single workbook often contains very different kinds of sheets β€” a compact summary that fits comfortably in portrait, and a wide table with many columns that only works in landscape. Excel lets you set orientation on a per-sheet basis, so you never have to compromise one layout to accommodate the other.

Also Worth Setting: Fit to Page

If a wide sheet still spills onto extra pages even in landscape, it is worth also learning how to use the fit-to-page print setting β€” combined with per-sheet orientation, you can get almost any table to print cleanly on a single page.

Frequently Asked Questions

What happens if I change orientation while multiple sheets are selected together?

Changing orientation while sheets are grouped applies that same orientation to every selected sheet, so if you need different settings per sheet, select and change them one at a time.

Can I confirm the orientation directly in print preview?

Yes, opening "File > Print" and checking the preview shows immediately whether the orientation you set was applied correctly.