The problem with Excel PDFs
Anyone who has ever exported an Excel spreadsheet as a PDF knows the surprise: the table is split across multiple pages, columns are cut off, or the last page contains only two rows in a large white space. Exporting from Excel is technically simple, but without the right settings the results are rarely satisfying.
This article shows how to prepare Excel spreadsheets so that the resulting PDF looks professional, whether for internal reports, client presentations or print outputs.
Define the print area
The most important step before exporting: defining the print area. Without a print area, Excel simply prints all cells that contain content, including hidden formulas and helper columns not intended for the PDF reader.
How to set the print area in Excel:
- Select the desired range
- Go to "Page Layout" tab → "Print Area" → "Set Print Area"
- Enable the Page Layout view to preview the result
Scaling: getting everything on one page
For tables that need to fit on one page, Excel's scaling function is the solution. Under "Page Layout" → "Scale to Fit", you can configure the table to print exactly 1 page wide and as many pages tall as needed. This setting prevents columns on the right side from being cut off.
Important: too much scaling makes numbers and text unreadable. The font size in the final PDF should be at least 8-9pt.
Page orientation and paper format
Wide tables often fit better in landscape orientation. This can be set in Excel under "Page Layout" → "Orientation" → "Landscape". For particularly wide tables, a different paper format (A3 instead of A4) may also make sense, if the document will be used digitally and does not need to be printed.
Headers and footers
Professional PDFs from Excel include headers and footers with relevant information: page number, date, table name or company logo. These can be configured in Excel via "Insert" → "Header & Footer" and will appear on every page of the PDF.
Gridlines and cell borders
By default, Excel does not print gridlines. This makes tables without explicit borders difficult to read in a PDF. Recommendation: either add explicit borders to cells in Excel, or enable "Page Layout" → "Gridlines" → "Print".
Exporting Excel as PDF, methods compared
Via "Save As" as PDF
Directly in Excel: "File" → "Save As" → Format "PDF". Advantage: quick and simple. Disadvantage: limited control over PDF quality settings.
Via "Export" → "Create PDF/XPS"
Slightly more control: here you can select quality level and optimization for print or screen.
Online converter for complex cases
When Excel is not installed on the device being used, or when the direct export result is unsatisfactory, an online converter can help. With Excel to PDF, XLSX files can be converted directly in the browser.
Multiple worksheets as a single PDF
When a workbook contains multiple sheets and all should end up in one PDF, there are two approaches:
- In Excel, select all sheets (Shift + click on tabs) and then save as PDF, all selected sheets become one PDF
- Alternatively, export each sheet as its own PDF and then combine them using merge PDF
Common problems and solutions
- Table spreads across too many pages → reduce the print area, adjust scaling
- Columns are cut off → choose landscape orientation or set scaling to "1 page wide"
- Numbers appear as "#####" → widen columns to sufficient width before exporting
- Charts appear distorted → scale charts in Excel to the desired aspect ratio before exporting
- Empty last page → check if there is a stray cell below the actual data range
Conclusion
Creating a professional PDF from Excel requires some preparation, but it is not complicated. Anyone who has correctly set up the print area, scaling and layout can reuse the same settings as a template for similar documents. The result is a PDF that looks exactly as the spreadsheet should look, on every device and for every recipient.