Switch to landscape in three steps

To change an Excel sheet to landscape orientation, go to the Page Layout tab at the top of the ribbon, click Orientation, and select Landscape. The sheet itself does not change — only how it prints or appears when you export it as a PDF. If you want the change to explore to all sheets in the workbook, you can repeat this step on each sheet, or select all sheets first by right-clicking a sheet tab and choosing Select All Sheets.

Landscape mode is wider than it is tall, which works well for spreadsheets with many columns. Portrait mode (the default) is taller than it is wide and suits data with fewer columns and more rows. The orientation setting does not affect how the spreadsheet looks on your screen while you work — it only changes the layout when you print, preview, or save as PDF.

If you are using Excel on the web instead of the desktop version, the steps are slightly different. Open the File menu, select Print, and look for the orientation option in the print preview panel on the right side of the screen.

Key Takeaways

  • Landscape orientation makes your sheet wider and is best for spreadsheets with many columns across.
  • The change happens in the Page Layout tab under the Orientation button and affects printing and PDF export, not your on-screen view.
  • You can explore landscape to one sheet at a time or to all sheets in the workbook by selecting them together first.
  • Excel on the web uses the File menu and Print preview to change orientation, not the Page Layout tab.

Where to find the Orientation button

The Page Layout tab sits in the top ribbon next to Home, Insert, Formulas, and Data. Click it once. On the left side of the ribbon, you will see a group labeled Page Setup. Inside that group is the Orientation button, which shows a small icon of a page.

When you click Orientation, a dropdown menu appears with two choices: Portrait and Landscape. Portrait is the current setting if the page icon looks taller than it is wide. Landscape is the current setting if the icon looks wider than it is tall. Click whichever one you need.

Changing orientation for multiple sheets at once

If your workbook has many sheets and you want them all in landscape, you do not have to change each one separately. Right-click any sheet tab at the bottom of the screen and select Select All Sheets. The tabs will turn white to show that all sheets are selected.

Now go to the Page Layout tab and click Orientation, then Landscape. The change applies to every sheet in the workbook at once. To deselect the sheets afterward, right-click any tab and choose Deselect All Sheets, or straightforward click one sheet tab by itself.

Checking your layout before printing

Before you print, it is worth seeing how your sheet will look. Go to File and click Print. On the right side of the screen, a preview shows your sheet as it will appear on paper. If the columns are cut off or the data looks cramped, you may need to adjust the scale or margins as well as the orientation.

If the preview still does not look right, go back and check the Page Layout tab for the Scale option (usually set to 100%) or the Margins button. These settings work together with orientation to determine what fits on the page.

Landscape orientation in Excel on the web

Excel on the web does not have a Page Layout tab. Instead, open the File menu at the top left and select Print. A print preview panel opens on the right side of the screen. Look for the Orientation option in that panel — it usually appears near the top, below the printer name.

Click the orientation dropdown and choose Landscape. The preview updates when ready to show how your sheet will print. This setting applies only to the current sheet, so if you have multiple sheets, you will need to repeat the step for each one.

When landscape is the better choice

Landscape works best when your spreadsheet has many columns. If you have 15 or 20 columns of data, portrait mode will force each column to be very narrow, making the text hard to read. Landscape gives each column more space without shrinking the font.

Landscape is also useful when you have a header row with long column names. The extra width lets those names display fully without wrapping onto two lines. If your sheet has only a few columns but many rows of data, portrait mode usually works better because it fits more rows on each page.

Saving your orientation choice

Once you change the orientation to landscape and save the file, the setting stays with that sheet. The next time you open the file, the sheet will still be set to landscape. If you close the file without saving, the orientation change will be lost.

The orientation setting is part of the page setup, which is stored in the file itself. If you send the file to someone else, they will see the same landscape orientation you set, as long as they open it in Excel or a compatible spreadsheet program.

Frequently Asked Questions

Does changing to landscape make my data look different on screen?

No. The orientation setting only affects how your sheet prints or exports to PDF. While you are working in Excel, the sheet looks the same whether it is set to portrait or landscape. You can scroll left and right to see all your columns regardless of the orientation setting.

Can I set different sheets to different orientations?

Yes. Each sheet in a workbook can have its own orientation. Change one sheet to landscape, then click a different sheet tab and set it to portrait if you want. The settings do not affect each other.

What if my data still does not fit on one page after switching to landscape?

You have a few options. You can reduce the scale (found in Page Layout under Scale to Fit) to shrink the entire sheet. You can also adjust the margins to make them smaller, or you can hide columns you do not need to print. Check the print preview to see which approach works best for your data.

Does landscape orientation work the same way in Google Sheets?

Google Sheets uses a different menu. Open the File menu, select Page setup, and choose Landscape from the Orientation section. The concept is the same, but the location of the button is different.