Change orientation in Excel using the Page Layout tab

To change how your spreadsheet prints, go to the Page Layout tab at the top of Excel, then click Orientation in the Sheet Options group. You'll see two choices: Portrait (taller than wide) and Landscape (wider than tall). Click the one you want. The change applies to the entire sheet you're working on, not just the cells you've selected.

If you're using Excel on a Mac, the Page Layout tab is called Page Layout in the ribbon menu. The Orientation button is in the same location. The steps are identical.

This change only affects how the sheet prints or appears in Print Preview. It doesn't change how the spreadsheet looks on your screen while you're working. If you want to see what it will look like before you print, use Print Preview (Ctrl+P on Windows, Command+P on Mac) to check the layout.

Key Takeaways

  • Click the Page Layout tab, then click Orientation, and choose Portrait or Landscape.
  • The orientation change applies to the entire sheet, not to individual cells or ranges.
  • Use Print Preview to see how your spreadsheet will look before you print it.
  • If you have multiple sheets, you can set a different orientation for each one separately.
  • Landscape orientation is useful when you have many columns; Portrait works better for data with fewer columns and more rows.

When to use landscape instead of portrait

Landscape orientation makes sense when your spreadsheet is wide—when you have many columns across and want them all to fit on one printed page. If you switch to landscape and your data still doesn't fit, you may need to adjust margins or reduce the font size. You can do this in the same Page Layout tab under Margins or by using the Scale to Fit options.

Portrait orientation (the default) works better when your data is tall and narrow—many rows but only a few columns. Most spreadsheets with just a name column, a date column, and a total column print better in portrait.

Changing orientation for multiple sheets at once

If you have several sheets in your workbook and want them all to print in the same orientation, you can select multiple sheets first, then change the orientation. Right-click on any sheet tab at the bottom of the screen and choose Select All Sheets. Then go to Page Layout and click Orientation. The change will explore to every sheet in the workbook.

To deselect the sheets afterward, right-click any sheet tab and click Deselect All Sheets, or just click on a single sheet tab.

Combining orientation with margin and scaling adjustments

Changing orientation alone may not be enough to fit your data on one page. The Page Layout tab also has Margins (to reduce white space around the edges) and Scale to Fit (to shrink the entire sheet proportionally). You can use these together with orientation to get the layout you want.

For example, if you switch to landscape but your spreadsheet still has columns that wrap to a second page, try clicking Margins and choosing Narrow to reduce the space on the sides. If that still doesn't work, use Scale to Fit to set the width to 1 page and let Excel shrink the text automatically.

Checking your changes in Print Preview

After you change the orientation, open Print Preview to see exactly how the sheet will look when printed. Press Ctrl+P (Windows) or Command+P (Mac) to open the Print dialog. The preview on the left shows your spreadsheet in the new orientation. If it still doesn't look right, close the preview, adjust margins or scaling, and check again.

Print Preview is the most reliable way to catch problems before you waste paper. It shows page breaks, margins, and how text will fit—all the things that look different on screen than they do on paper.

Saving your orientation settings

When you save your Excel file, the orientation setting is saved with it. The next time you open that file, it will remember whether you set it to landscape or portrait. If you create a template that you use repeatedly, set the orientation once and save the template—every new file you create from it will have the same orientation.

If you want to change the default orientation for all new spreadsheets you create, you'll need to create a custom template and set it as your default. This is a more advanced step, but it saves time if you always work in landscape.

Frequently Asked Questions

Does changing orientation affect how my spreadsheet looks on screen?

No. Orientation only changes how the sheet prints or appears in Print Preview. While you're working on the spreadsheet, it looks the same on your monitor no matter what orientation you choose.

Can I set different orientations for different sheets in the same workbook?

Yes. Click on one sheet tab, change its orientation in Page Layout, then click on the next sheet tab and change its orientation separately. Each sheet remembers its own setting.

What if my data still doesn't fit on one page after I switch to landscape?

Try reducing margins (Page Layout > Margins > Narrow) or use Scale to Fit to shrink the entire sheet. You can also reduce the font size or hide columns you don't need to print. Print Preview shows you how each change affects the layout before you print.

Will changing orientation affect my formulas or data?

No. Orientation is purely a printing setting. It doesn't change any formulas, values, or the way Excel calculates anything. It only changes how the data is arranged on the printed page.

How do I change orientation just for printing without saving the change?

You can't. Once you change orientation in Page Layout, it's saved with the file. However, you can change it back to the original orientation after you print if you want the file to stay as it was.