In Excel: use File ▸ Export ▸ Create PDF/XPS Document (or File ▸ Save As and pick PDF) — but set the print area, orientation and Scale to Fit width first, because the PDF is a print, not a screenshot.
Select the range you want and set Page Layout ▸ Print Area ▸ Set Print Area.
Choose Landscape and Narrow margins if the table is wide.
Set Page Layout ▸ Scale to Fit ▸ Width: 1 page, Height: Automatic so columns stay together.
Check the page breaks in View ▸ Page Break Preview and drag them if needed.
File ▸ Export ▸ Create PDF/XPS Document (or File ▸ Save As ▸ PDF).
Click Options to choose Selection, Active sheet(s), Entire workbook or a page range, then Publish.
What this does
Excel produces a PDF through the print engine, so everything that governs printing governs the PDF: print area, orientation, margins, scaling, page breaks, headers and footers, and whether gridlines print. A PDF exported without touching those settings splits a wide table across pages exactly as a careless printout would. The Options button in the export dialog is where you choose Selection, Active sheet(s) or Entire workbook, and a page range. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. For “export to pdf excel”, the reliable version is a short checking loop, not just the first command that appears to work. Run it on a deliberately small range first, watch how the affected cells change, and only then apply the same setup to the full sheet. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That is what makes a data step that keeps your analysis trustworthy useful in real work: repeatable, auditable, and not dependent on memory or luck.
A worked example
A 14-column table exports as 8 disjointed pages. Set Page Layout ▸ Orientation ▸ Landscape, Margins ▸ Narrow, and Scale to Fit ▸ Width: 1 page, Height: Automatic. Check View ▸ Page Break Preview shows one column of pages. Then File ▸ Export ▸ Create PDF/XPS ▸ Options ▸ Active sheet(s) ▸ Publish. The result is 3 clean pages, each with all 14 columns. A PDF is how a spreadsheet leaves the building — for a client, an approval or an archive — and it is the moment the print layout stops being optional. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
Everything above works in Google Sheets too. Excel and Sheets share the formula syntax used here; only the surrounding menus are arranged differently. That portability is deliberate — learn it once and it follows you between the two tools and across Windows and Mac. Nothing on this page is behind a login: the tool runs entirely in your browser, the formula is shown in full with one-click copy, and the steps work the same on Windows and Mac. That is the whole promise here — the exact answer, a way to prove it on your own numbers, and just enough context to make it stick. The short version of “export to pdf excel”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Exporting before setting the print area, so blank columns become extra pages.
- Choosing Entire workbook when only one sheet was meant, which quietly publishes hidden working sheets.
- Assuming the PDF will look like the screen; it looks like the printout, including page breaks and missing gridlines.
- Leaving Fit Sheet on One Page selected on a long table, producing unreadable 25% text.
- Forgetting that a PDF freezes the numbers — send the workbook if the recipient needs to change anything.
Frequently asked questions
How do I convert an Excel file to PDF?
File ▸ Export ▸ Create PDF/XPS Document, or File ▸ Save As and choose PDF in the file-type list. Both go through Excel's print settings.
How do I export only one sheet or one selection?
In the export dialog click Options and choose Selection, Active sheet(s) or a page range before publishing.
Why is my PDF split across so many pages?
The print settings, not the export, decide that. Set a print area, switch to Landscape, and set Scale to Fit ▸ Width to 1 page.
Can I make a PDF from Excel on the web?
Yes — File ▸ Print ▸ Print to PDF in Excel for the web, though the layout controls are more limited than in the desktop app.
Other ways people ask this
People reach this page typing “how to export pdf to excel”, “export pdf to excel”, “how to export excel to pdf” and “pdf export to excel”, among other phrasings; whichever wording you used, the fix above is the one you want.
Platform & version notes
- If you are on a Mac, nothing here changes except the modifier key: swap Ctrl for ⌘ in every shortcut, and use the Windows/Mac toggle at the top of the page so the keystrokes shown match the keyboard in front of you.
How is it different on a Mac?
Only the keys. Press ⌘ where Windows uses Ctrl; the menus, formulas and result for "export to pdf excel" are the same on macOS as on Windows.
Why do people search for this in so many different ways?
Because the same task has many names. “how to export pdf to excel”, “export pdf to excel”, “how to export excel to pdf” all point at the one operation explained on this page, which is why they all lead here.