How to Change to Landscape in Excel

Q: How do I change to landscape in Excel quickly?

Go to the Page Layout tab, click Orientation, and choose Landscape. The sheet switches immediately. You can also set it from File → Print using the orientation dropdown in the print preview.

Q: How do I change to landscape in Excel on a Mac?

Click the Page Layout tab and choose Orientation → Landscape, or go to File → Page Setup, pick Landscape on the Page tab, and click OK. You can also set it from File → Print.

Q: How do I print an Excel document in landscape?

Go to File → Print (Ctrl + P on Windows, Command + P on Mac), select Landscape from the orientation dropdown, confirm the preview looks right, and click Print.

To change to landscape in Excel, go to the Page Layout tab, click Orientation, and choose Landscape — your sheet immediately switches to print wider than it is tall. Orientation is set per worksheet, so repeat it on each sheet (or select all sheet tabs first) and pair it with Scale to Fit if your data is too wide for one page.

Microsoft Excel is a powerful program, useful for individuals and businesses alike. One commonly asked question in the Excel community is how to change the orientation of a spreadsheet from portrait to landscape. This simple shift can make the difference in readability and overall presentation. In this guide, we’ll walk through every way to change to landscape in Excel, on both Windows and Mac, so you can make the most out of your data presentation.

Why Change to Landscape in Excel?

Before we get started, let’s first understand why changing to landscape orientation is important. By default, Excel opens documents in portrait orientation, which is great for presenting information from top to bottom. However, when you have a wide table or chart, switching to landscape can greatly improve readability. Changing to landscape orientation in Excel is easy and can help you display your data more efficiently.

Landscape vs. Portrait Orientation

The two orientations describe how your page is turned when it prints:

Portrait — the page is taller than it is wide (the default). Best for long, narrow lists where you have only a few columns but many rows.
Landscape — the page is wider than it is tall. Best for wide tables, dashboards, charts, and anything with many columns, because the extra horizontal space stops columns from spilling onto a second page.

Orientation only changes how the sheet is printed and how the printed page is laid out — it does not rotate your cells, formulas, or data. If you find your data is still too wide even in landscape, that is a job for Scale to Fit (covered below), not a different orientation.

Step-by-Step Guide: How to Change to Landscape in Excel (Windows)

Step 1: Open your Excel document

After you’ve opened up your Excel document, locate the “Page Layout” tab in the ribbon at the top of your screen.

Step 2: Click on the “Orientation” button

Next, locate the “Orientation” button. Click on it to reveal a drop-down list of options to choose from.

Step 3: Select “Landscape” orientation

From the drop-down list, select “Landscape” orientation. Your document will automatically switch to landscape, allowing you to see your data from left to right instead of top to bottom.

Step 4: Adjust page margins (Optional)

If necessary, you can adjust your page margins to further optimize the space on the page. This can be found on the same “Page Layout” tab, under the “Margins” section. By default, Excel will provide you with a standard margin, but you have the option to change them to fit your specific presentation needs.

There you have it, a quick and easy guide on how to change to landscape in Excel. This can save you and your audience time and increase readability of your data. Be sure to experiment with different orientations and margin settings, to find the right layout that works best for your specific document.

Setting Landscape in Print Preview

You don’t have to leave the print screen to switch orientation. Go to File → Print (or press Ctrl + P) to open the print preview. In the settings list on the left, there is an orientation dropdown that reads Portrait Orientation by default — click it and choose Landscape Orientation. The preview on the right updates instantly, so you can confirm everything fits before sending the job to the printer. Whatever you pick here is saved with the worksheet, exactly as if you had set it on the Page Layout tab. This is also the fastest place to check the result against your overall print layout.

Landscape Is Per-Worksheet (How to Apply It to Every Sheet)

Orientation is a per-worksheet setting. Switching one tab to landscape does not change the others in the same workbook, which is why a report can print some sheets wide and others tall. You have two options:

Set each sheet individually — click each worksheet tab and repeat the Page Layout → Orientation → Landscape steps.
Apply landscape to all sheets at once — right-click any sheet tab and choose Select All Sheets (or click the first tab, then Shift-click the last). With every tab grouped, set the orientation once and it applies to all of them. Important: right-click a tab and choose Ungroup Sheets when you’re done, otherwise edits you make to one sheet will be mirrored across all of them.

Fitting Wide Data to the Page Width (Scale to Fit)

Switching to landscape often isn’t enough on its own when a table has a lot of columns. The Scale to Fit group on the Page Layout tab solves this:

Set Width to 1 page to squeeze all your columns onto a single page width while letting the rows flow onto as many pages as needed. This is the single most useful setting for wide reports.
Leave Height at Automatic unless you also want to compress vertically.
The Scale percentage box does the same thing manually — drop it below 100% to shrink everything uniformly.

For a deeper walkthrough of squeezing a report down, see how to fit an Excel sheet to one page. You can also control exactly what prints by setting a print area so only the range you care about is scaled.

How Margins, Print Area, and Page Breaks Interact

Orientation is one piece of a larger print layout. A few related settings work alongside it:

Margins — narrower margins give landscape even more usable width. Use Page Layout → Margins → Narrow, or set custom margins.
Print area — if a defined print area is narrower than the sheet, landscape and Scale to Fit only apply to that range, which can be exactly what you want for a clean printout.
Page breaks — after switching to landscape, your page breaks may shift. Use Page Break Preview (View tab) to see and drag them.
Print titles — for multi-page tables, turn on repeating header rows so column labels show on every page.

Printing in Landscape

Changing to landscape orientation in Excel is especially useful when it comes to printing. When you want to print your spreadsheet, the landscape orientation will make the most out of the available space on the page and reduce the number of pages you need to print. This can save you money on printing expenses and reduce the amount of paper waste. If you want supporting lines on the page, you can also print gridlines or add cell borders and lines, and add a header for titles and page numbers.

Creating Custom Page Layouts

If your Excel document has multiple worksheets and you want to have different page layouts, you can create custom page layouts and apply them to specific worksheets. This can be done by selecting the desired worksheet tab, going to Page Layout > Page Setup, and selecting the orientation, margins, and other settings you desire. Save your custom page layout, and the next time you switch to that worksheet, the custom page layout will be ready for use.

Changing to Landscape on a Mac

The process is nearly identical in Excel for Mac:

Open your workbook and click the Page Layout tab on the ribbon.
Click Orientation, then choose Landscape.

Alternatively, go to File → Page Setup, and on the Page tab choose Landscape under Orientation, then click OK. You can also set orientation from the print screen: File → Print, then pick Landscape from the orientation control in the print dialog. As on Windows, orientation is per-worksheet on the Mac, so select all sheet tabs first if you want every sheet to print landscape.

Windows vs. Mac at a Glance

Task	Windows	Mac
Ribbon path	Page Layout → Orientation → Landscape	Page Layout → Orientation → Landscape
Dialog path	Page Layout → Page Setup → Page tab	File → Page Setup → Page tab
From print screen	File → Print → orientation dropdown	File → Print → orientation control
Open print preview	Ctrl + P	Command + P

The ribbon layout is the same on both platforms; the main difference is that Mac uses the File → Page Setup dialog where Windows uses the small Page Setup launcher arrow on the ribbon.

Excel Keyboard Shortcuts

If you’re a frequent Excel user, you know that using keyboard shortcuts can save you a lot of time. On Windows, you can open the print screen with Ctrl + P and change orientation there, or press Alt → P → O → L in sequence to jump straight to the Page Layout Orientation menu and pick Landscape. There is no single dedicated, built-in keystroke for landscape that is consistent across all Excel versions, so the print screen and the ribbon remain the most reliable routes.

Troubleshooting

My other sheets are still printing portrait. Orientation is per-worksheet — set it on each tab, or select all sheets first (then ungroup afterward).
Landscape didn’t fix my columns spilling onto a second page. Orientation alone won’t shrink wide data. Set Scale to Fit Width to 1 page, or fit the sheet to one page.
The orientation keeps reverting. Make sure you’re not relying on a printer driver default. Set orientation in Excel (Page Layout or File → Print) rather than in the printer dialog, and save the workbook.
Only part of my data prints. A narrow print area may be limiting the output — clear or redefine it under Page Layout → Print Area.
Margins look wrong after switching. Reset them under Page Layout → Margins, or adjust margins manually.

Final Words

Changing to landscape orientation in Excel is a simple but effective way to improve readability and presentation. Whether you’re presenting data to colleagues, printing out a report, or creating a custom layout, switching to landscape orientation is a critical tool in your Excel arsenal. Remember to adjust your page margins, use Scale to Fit for wide tables, apply the setting to every worksheet, and use the print preview to confirm the result before you print.

Frequently Asked Questions

How do I change to landscape in Excel quickly?

Go to the Page Layout tab, click Orientation, and choose Landscape. The sheet switches immediately. You can also set it from File → Print using the orientation dropdown in the print preview.

What is the difference between landscape and portrait orientation?

Landscape orientation is when your document is wider than it is tall, with data displaying from left to right — ideal for wide tables and charts. Portrait orientation is taller than it is wide, with data displaying from top to bottom — better for long, narrow lists.

Why is only one of my worksheets printing in landscape?

Orientation is a per-worksheet setting, so changing one tab doesn’t affect the others. To apply landscape to the whole workbook, right-click a sheet tab, choose Select All Sheets, set the orientation once, then ungroup the sheets when you’re done.

How do I change to landscape in Excel on a Mac?

Click the Page Layout tab and choose Orientation → Landscape, or go to File → Page Setup, pick Landscape on the Page tab, and click OK. You can also set it from File → Print.

Landscape still won’t fit all my columns on one page — what now?

Orientation alone doesn’t resize data. On the Page Layout tab, use the Scale to Fit group and set Width to 1 page, or follow our guide on fitting an Excel sheet to one page. Narrowing your margins helps too.

How do I print an Excel document in landscape?

Go to File → Print (Ctrl + P on Windows, Command + P on Mac), select Landscape from the orientation dropdown, confirm the preview looks right, and click Print.