How to Convert Excel to PDF Without Splitting Your Tables
Spreadsheets are the worst possible fit for a printed page: wide, tall, and designed to scroll rather than break. Converting to PDF without preparing the sheet produces columns that vanish off the right edge and tables that split mid-row. Ten minutes of preparation saves a document nobody can read.
The core problem
A spreadsheet has no pages. It has a grid that goes on indefinitely in both directions. A PDF has fixed pages with a printable area. The conversion has to decide where to break the grid, and its default decisions are rarely the ones you want.
Everything below is about controlling those breaks before the conversion happens, because fixing it afterwards is much harder.
Prepare the sheet first
- Select the print area. Highlight exactly the cells you want, then set it as the print area. Without this, the converter includes every stray cell, including the empty ones that make the sheet enormous.
- Fit the width to one page. In the page setup, choose "fit all columns on one page". This is the single biggest improvement.
- Set landscape for wide tables. Most financial tables are wider than they are tall.
- Repeat the header row. Tell Excel to repeat row 1 at the top of every printed page, or the second page becomes a wall of numbers with no labels.
- Remove gridlines and set a margin. Screen gridlines do not print; cell borders do. Check which you have.
Convert
- Save the workbook after the page setup changes — some converters read the stored print settings.
- Open Excel to PDF and add the file.
- Choose the sheet or sheets to convert. Converting the whole workbook produces one PDF section per sheet, which is right for a report and wrong for a single table.
- Convert and open the result. Check the right edge of page one: that is where columns get cut.
- Check whether the header row appears on page two.
Fixing the usual damage
- Columns cut off: the print area is wider than the page. Go back to the workbook, set landscape, and fit to one page wide.
- One table spread across many pages: reduce the font, narrow the columns, or split the table deliberately into two tables that each fit.
- Numbers show as ####: the column is too narrow for the value. Widen the column in the spreadsheet; the PDF shows exactly what Excel shows.
- Formulas show as text: the sheet was saved with formulas displayed instead of values. Switch the setting and re-save.
- Colours look different: the sheet uses a theme colour that does not exist in the PDF export. Use standard colours for anything that will be printed.
- The file is huge: an Excel sheet with thousands of formatted cells produces a heavy PDF. Convert only the used range, not the whole sheet.
When a spreadsheet should stay a spreadsheet
If the recipient needs to sort, filter or add rows, send the .xlsx. A PDF of a spreadsheet is a report, not data.
If the data is going to be processed, send CSV. It is smaller, universally readable, and has no formatting to corrupt.
PDF is the right choice when the numbers are final, the layout matters, and the recipient should see exactly what you approved — an invoice, a financial statement, a printed schedule.
Privacy
Spreadsheets hold salaries, customer lists, bank details and pricing. Uploading one to a converter means handing over the complete dataset, not a page of it.
A browser-based converter parses the workbook and builds the PDF locally. The file never leaves your machine, which for a payroll sheet is the only acceptable arrangement.