Short answer: Converting Excel to PDF means turning a table or worksheet into a fixed document that looks the same even if the recipient doesn't have Excel installed. The goal of this conversion is to keep cell widths, row heights, and page layout identical on everyone's screen. It's usually preferred when sharing reports, invoices, quotes, or lists.
What is converting Excel to PDF and why is it done?
Converting Excel to PDF is the process of turning a source table into a fixed, non-editable (read-only) document. Because PDF embeds the font, cell borders, and page layout inside the document, rows don't shift and columns don't overflow when the file is opened on another computer.
Its biggest practical benefit is that the table looks the same even if Excel isn't installed on the recipient's side. PDF files also make it harder to accidentally change a formula; this preserves data integrity when sharing quotes, budgets, and reports. If you need to share editable data, you can use the Excel → CSV converter to export the table as flat data; PDF, on the other hand, is suitable for fixed output that will be read and archived.
How do you convert Excel to PDF?
The most reliable way to convert Excel to PDF is to first set the print area and page layout, then convert. Converting directly often causes columns to overflow onto a second page. You can follow these steps:
- Define the print area. Select only the cell range you want in the PDF; this way empty columns and unused rows aren't added to the document.
- Choose the page orientation. Landscape for wide tables and portrait for long, narrow lists give a more readable result.
- Set the page size. A4 is enough for most documents and printers; A3 can be preferred for large technical tables.
- Check the scaling. The "Fit all columns on one page" option prevents overflow, but be careful not to shrink the text too much.
- Mark repeating headers. For tables that span multiple pages, make the top row repeat on every page.
- Perform the conversion. Give your ready Excel file to the [XLSX → PDF](/tool/excel-to-pdf) tool to get a PDF whose cell and formula structure is preserved.
These steps work both in the desktop Excel application and in online converters. What matters is to clarify the page layout before converting.
Which page size and orientation should you choose?
Which page size and orientation you choose depends on the number of columns in your table and the purpose of use. As the number of columns increases, landscape orientation and a wider paper size increase readability. The table below gives a general direction:
| Situation | Recommended size | Recommended orientation | Why |
|---|---|---|---|
| Standard report, invoice | A4 | Portrait | The most common ratio for printer and screen |
| Multi-column budget table | A4 | Landscape | Makes it easier for the columns to fit on the page |
| Wide technical table | A3 | Landscape | Holds more data on a single page |
| Long name list | A4 | Portrait | Row-based reading is more comfortable |
When making your choice, think about where the document will be used: if it will be read on screen, a landscape and wide page is more comfortable; if it will be printed, A4 portrait is enough in most cases.
Why does the table break when converting from Excel to PDF?
The most common cause of a table breaking when converting from Excel to PDF is that the print area and scaling haven't been set. The Excel worksheet appears unlimited on screen, but the PDF is fitted to a specific paper size; that's why a wide table is automatically split.
To prevent breaking, pay attention to these points:
- Widen text columns manually instead of using "Shrink to fit"; automatic shrinking can clip cell contents.
- Use wrap text inside cells for very long texts.
- Check page breaks in the preview; manually fix columns that break at an unexpected place.
- Place charts on a separate page rather than right next to the table, so they don't shift during conversion.
If you only need to transfer the data to another application, converting the table into a plain text-based format instead of PDF may be more practical; the Excel → CSV tool is suitable for this. If keeping the document visually fixed is the priority, PDF is the right choice.
How do you check quality after conversion?
The way to check quality after conversion is to open the resulting PDF and review the page count, column overflows, and font size. Since PDF is a fixed document, later corrections you make in the source Excel aren't reflected in the PDF; that's why checking right after conversion is the most practical approach.
When checking, look at these:
- Is the total page count as you expected?
- Is the last column left alone on the last page (this is usually a sign of overflow)?
- Does the header row appear on every page?
- Is the font size readable on screen and in print?
If you see a problem, fix the setting in the source file and convert again. If the document will only be shared on screen, the output produced with XLSX → PDF is enough; no additional visual editing is needed.
Frequently asked questions
Do formulas disappear when you convert Excel to PDF?
No, formulas are usually reflected in the PDF as calculated result values; however, formulas can't be edited inside the PDF document, because PDF is a fixed output format.
What is the best page size for Excel to PDF conversion?
A4 portrait is the most suitable option for most reports and documents. For multi-column tables, A4 landscape, and for wide technical tables, A3 landscape give more readable results.
Should I choose PDF or CSV?
If you want the document's appearance to stay fixed and non-editable, choose PDF; if you'll transfer the data to another program, choose CSV. The Excel → CSV converter is useful for flat data output.
Why is the table split in the PDF?
When wide tables don't fit the chosen paper size, Excel automatically splits the content. Narrowing the print area, choosing landscape orientation, and adjusting scaling usually resolve this splitting.
Can I edit the converted PDF afterward?
Since PDF is a fixed format, text and table editing is limited. If you need to make changes, the healthiest method is to update the source Excel file and convert again.