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.
On this page7
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. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “convert excel to pdf”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. 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. The point is a data step that keeps your analysis trustworthy, but the practical win is that someone else can open the file and understand what happened without asking you.
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 this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.
In Google Sheets
This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. Treat “convert excel to pdf” as a routine rather than a one-off. Once you know which setting or command controls it, the same few steps handle every workbook where it comes up in Excel, and you can explain them to a colleague in a sentence.
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 convert excel to pdf format”, “how to convert an excel to pdf”, “how do you convert excel to pdf” and “how can i convert an excel file to pdf”, 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.
- Some variants pin a specific edition (the web version). The method above is stable across recent Excel releases — older versions only differ in where a ribbon icon sits, not in what the steps achieve.
Does this still work in older versions?
It does. The approach has been stable across recent Excel releases; only the ribbon icons have shifted cosmetically, so the steps above still apply.
How is it different on a Mac?
Only the keys. Press ⌘ where Windows uses Ctrl; the menus, formulas and result for "convert excel to pdf" are the same on macOS as on Windows.