Converting a spreadsheet to PDF is the safest way to share a report, a quote or an invoice: the recipient sees it exactly as you designed it, on any device, and cannot change the data by accident. Yet we have all seen PDFs exported from Excel with columns spilling onto another page, twenty almost empty pages or text so small it is impossible to read. With a few adjustments beforehand, the result can be flawless.
Why share as PDF
- Fixed layout: it looks the same on a computer, a tablet or a phone.
- No accidental changes: the recipient cannot alter formulas or values.
- Print-ready: it respects margins, page size and breaks.
- Professional: ideal for quotes, invoices, reports and proposals.
- Universal: no need to have Excel to open it.
Step 1: set the print area
By default Excel prints every cell that contains something, including helper notes, intermediate calculations or a forgotten cell in column Z. Select only the range you want to show and go to Page Layout > Print Area > Set Print Area. This simple step prevents most blank pages.
Step 2: choose the right orientation
- Portrait: for long lists with few columns, such as a contact list.
- Landscape: for wide tables with many columns, such as a monthly sales report.
If your table has more than six or eight columns, landscape is usually the best choice.
Step 3: adjust the scaling
The most useful option is Fit All Columns on One Page (in Page Layout > Scale to Fit, set the width to 1 page and the height to automatic). That way columns are never cut off and rows continue onto the following pages.
Avoid fitting a large workbook onto a single page: the text will be tiny. As a rule of thumb, do not go below 60-70% scaling.
Step 4: repeat the headers
If the table spans several pages, readers need to see the column titles on each one. Go to Page Layout > Print Titles and under “Rows to repeat at top” select the header row.
Step 5: review page breaks
Page Break Preview (View tab) shows in blue where each page starts and ends. You can drag the lines so a section is not split, for example so a block of totals does not end up alone on the last page.
Step 6: header and footer
Add useful information in the header or footer: document name, date, page number (“Page 1 of 5”) and, if you like, your company logo. It looks professional and makes printed pages easier to keep in order.
Step 7: polish the formatting
A few details that greatly improve the PDF:
- Turn off gridlines and use borders only where they add clarity.
- Adjust column widths so “####” does not appear.
- Use a readable font size (at least 10-11 points).
- Right-align numbers and use the same number of decimals.
- Highlight totals with bold or a soft color.
Converting Excel to PDF online
Once your sheet is ready, you can export from Excel with File > Export > Create PDF, or use the Excel to PDF converter on our Excel tools page if you do not have Excel installed or you work with XLS, XLSX, CSV or ODS files from any device:
- Upload your file.
- The tool creates the PDF following the page setup.
- Download the result and check it.
It is especially handy for turning CSV files, which have no page setup of their own, into readable documents.
Workbooks with several sheets
If you want several sheets in the same PDF, check the page setup of each one: every sheet has its own print area, orientation and scaling. Delete or hide helper sheets that should not appear in the final document.
Common mistakes
- Cut-off columns because the width was not fitted to one page.
- Blank pages caused by formatted cells or content outside the useful area.
- Unreadable text from squeezing too much data onto one page.
- No headers on the following pages.
- Confidential data in hidden columns that does appear when converting with some tools. Delete anything that should not be shared.
What if you need the reverse?
If you receive a PDF and need to work with its data, use our PDF to Excel converter to extract the tables into an editable spreadsheet.
Frequently asked questions
Why does my PDF have blank pages?
Usually because there are formatted cells, borders or stray whitespace outside the data area. Set a print area that includes only your table and the empty pages will disappear.
How do I include every sheet in a single PDF?
When exporting from Excel, choose “Entire Workbook” instead of “Active Sheets”. Check the page setup of each sheet first, because each one prints with its own settings.
Can I convert a CSV straight to PDF?
Yes. An Excel to PDF tool that accepts CSV produces a document with a neatly aligned table, which is very handy for printing system exports that have no formatting.
Does the PDF include formulas?
No. The PDF shows the result of the formulas exactly as it appears on screen, not the formulas themselves. If the recipient needs the formulas, send them the Excel file as well.
Conclusion
A good PDF from Excel starts with page setup: print area, orientation, scaling, repeated titles and reviewed page breaks. With five minutes of preparation, your reports and quotes will look professional. When you are ready, convert them with the tool on our free Excel tools page and share them with complete peace of mind.
Try our free tools
Compare, convert, merge and clean your spreadsheets right in your browser, with nothing to install.
