# Excel to PDF in landscape

Canonical HTML: [https://pdfpix.com/guides/excel-to-pdf-in-landscape/](https://pdfpix.com/guides/excel-to-pdf-in-landscape/)

Orientation in Excel is a page setting on each sheet, not on the workbook or the export. To get Excel to PDF in landscape, set it on the Page Layout tab for every sheet that needs it, then export. This guide covers doing that for several sheets at once, the browser tool's own orientation chip, and when rotating the PDF afterwards is the right answer.

## Steps

1. **Select the sheet.** Click the sheet tab. To set several sheets at once, hold Control on Windows or Command on a Mac and click each tab, which groups them.
2. **Set Landscape.** On the Page Layout tab click Orientation and choose Landscape. Grouped sheets take the setting together.
3. **Check the page breaks.** Open View, Page Break Preview. The dashed lines move with the wider page. Drag any that still cut a table.
4. **Export.** File, Export, Create PDF/XPS on Windows or File, Save As, PDF on a Mac. Ungroup the sheets afterwards by clicking any single tab.

## Orientation is per sheet

Every sheet carries its own page setup: orientation, paper size, margins, scaling, header and footer. Setting landscape on the summary sheet does nothing for the data sheet behind it. A workbook export can therefore mix portrait and landscape pages, which is correct when a wide table sits between two pages of notes.

The export itself has no orientation option. It reads each sheet's setting and writes the pages accordingly. The general export dialogue, including the choice between one sheet and the workbook, is in [Convert Excel to PDF](https://pdfpix.com/guides/convert-excel-to-pdf/).

## Setting landscape on many sheets

Group the sheets by clicking the first tab and Shift-clicking the last, or Control-clicking each one. The title bar shows Group. Any page setup change now applies to every grouped sheet, including Orientation, Margins and Scale to Fit. Click a single tab to ungroup before editing cells, because typing into a grouped sheet writes to all of them.

Right-click a tab and choose Select All Sheets to set the whole workbook to landscape in one move. Charts on their own chart sheets have their own orientation as well, and a chart sheet defaults to landscape whatever the data sheets do.

## Landscape in the browser tab

[Excel to PDF](https://pdfpix.com/excel-to-pdf/) reads each sheet's own orientation out of the workbook and starts there, so a file already laid out for landscape converts that way with nothing touched. An orientation chip overrides it for the whole job when the workbook was never set up, and the preview and the page count redraw at the new value before anything is written.

The trade runs the other way from Excel's: the browser tool applies one page setup to every sheet it prints, so a workbook that wants portrait notes around a landscape table still needs Excel's per-sheet settings. What the tool adds is the check. Every page of the finished PDF is rendered again and the cell text is compared in order before the download appears.

## Landscape and fitting the width

Landscape on A4 gives 297 millimetres of width against 210 in portrait, about 40 percent more. That is often enough to bring a cut-off column back onto the page at 100 percent scale, which is why it comes before any shrinking. If a column still spills, combine landscape with Scale to Fit Width 1 page, covered in [Fit an Excel sheet on one PDF page](https://pdfpix.com/guides/fit-an-excel-sheet-on-one-pdf-page/).

Check the Scale box after switching. Excel does not change the scale when you change orientation, so a sheet already at 70 percent stays there and may now fit at 100.

## Print dialogue, Mac and Google Sheets

The print preview under File, Print has an orientation menu that sets the same per-sheet value and redraws the preview. On a Mac, Excel's Page Layout tab has the same Orientation button, and the macOS print dialogue also offers orientation, though a PDF saved from there loses cell hyperlinks. Google Sheets sets orientation in the panel that opens from File, Download, PDF document.

Whichever dialogue sets it, the value is saved with the workbook, so the next export comes out the same way without another visit to Page Layout. A workbook shared by several people keeps the last setting anyone saved, so a colleague's portrait export the week before is the usual reason a sheet that was landscape has turned back.

## Rotating a PDF that is already exported

If the workbook is gone and all you have is a PDF with landscape content on portrait pages, or pages that display sideways, [Rotate PDF](https://pdfpix.com/rotate-pdf/) turns the pages in this tab by 90 degrees and reopens the result to check every page carries the new rotation. That fixes a page that is merely displayed the wrong way round.

It does not fix a portrait export with a cut-off column. The column is on the next page, and turning the page does not bring it back. For that the only route is back to the sheet and a new export. Rotating is for display; orientation is for layout.

## Checking the export

Open the PDF and look at the page shape. A landscape page is wider than it is tall in the viewer with no rotation icon needed. Check that a repeated header row appears at the top of each page if you set Print Titles, and that the footer's page numbers count the landscape pages in the right order with the rest of the workbook.

A wrong orientation is cheap to fix and expensive to miss, because it is the one thing a reader notices before any of the numbers. The other spreadsheet guides are under [PDF, Word and Excel help](https://pdfpix.com/guides/office/).

## Questions and answers

### Why did only one sheet come out landscape?

Orientation is set per sheet. Group the sheets first, or right-click a tab and choose Select All Sheets, then set Landscape once.

### Can one PDF have both portrait and landscape pages from Excel?

Yes, from Excel's own export: each sheet keeps its own orientation and the workbook export writes them in tab order. The browser tool applies one orientation to the whole job.

### Does landscape make the text smaller?

No. Orientation changes the page shape only. The Scale box keeps whatever value it had, so check it after switching.

### Can I fix a portrait PDF by rotating it?

Only if the content is sideways on the page. Rotate PDF turns the pages. A cut-off column stays on the next page and needs a new export.

### Where is landscape in Excel on a Mac?

On the Page Layout tab under Orientation, the same as Windows. Page Setup and the print preview offer it too.

## Related pages

- [Excel to PDF](https://pdfpix.com/excel-to-pdf/): Turn an Excel workbook into a PDF with every sheet on pages that fit. The file stays in your browser. No upload, no account needed.
- [Fit an Excel sheet on one PDF page](https://pdfpix.com/guides/fit-an-excel-sheet-on-one-pdf-page/): Get a wide Excel sheet onto one PDF page without cut-off columns. A guide, with the tool that does the job named in it.
- [Convert Excel to PDF](https://pdfpix.com/guides/convert-excel-to-pdf/): Turn an Excel workbook into a PDF, one sheet or all of them. A guide, with the tool that does the job named in it.
- [Rotate PDF](https://pdfpix.com/rotate-pdf/): Turn pages the right way up and keep them that way when saved. The file stays in your browser. No upload, no account needed.
- [PDF, Word and Excel help](https://pdfpix.com/guides/office/): Find the right guide for PDFs inside Excel, Word and other software. Every guide on the job, sorted by the problem you have.