How to Convert Your Order Excel Sheet to PDF Without Cutting Off Columns
Order lists, inventory sheets and reconciliation reports tend to grow wider over time — a new column for courier name here, a return-status column there — until printing or exporting to PDF starts chopping off the last few columns onto a second page, or off the sheet entirely. This is one of the most common (and most annoying) spreadsheet problems for sellers who need a clean printable copy of their order data.
Why columns get cut off in the first place
Excel's default print area is based on your page size and orientation, not on how many columns you have. If your sheet is wider than what fits on an A4 page in portrait orientation at 100% scale, Excel simply continues onto additional pages — and if your print area or page breaks weren't set up correctly, some columns can end up cut off mid-column rather than moved cleanly to a second page.
The usual (fiddly) fix in Excel
Excel has a "Fit to" scaling option under Page Setup that can shrink the sheet to fit a set number of pages wide — but it applies to the whole workbook print job at once, doesn't always account for merged cells or wrapped text well, and needs to be reconfigured any time you add a column or a new sheet. For a one-off report, this is manageable; for a recurring daily or weekly export, it gets tedious fast.
A more direct way: convert straight to PDF with fit-to-width
The Excel to PDF tool on this site is built specifically around this problem: it converts .xlsx, .xls, .ods or .csv files to PDF with every column automatically fitted to one page wide, per sheet, without needing to tune Excel's print settings first. In the browser:
- Upload your spreadsheet — nothing leaves your device during conversion.
- Choose which sheets to include if the file has multiple tabs.
- Set orientation (landscape is usually the right call for wide order tables) and whether header rows should repeat on every printed page.
- Preview and export — every column lands on the page instead of being cut off or pushed to a separate sheet.
When landscape still isn't enough: a genuinely very wide sheet (30+ columns) may need a smaller font or narrower columns even in landscape to stay legible once fitted to one page. If readability matters more than fitting every column on one physical page, it's sometimes better to split the sheet into two logical groups of columns (e.g. order details vs. shipping details) and export each separately rather than shrinking text to the point it's hard to read.
Keeping headers readable across pages
For long order lists that still span multiple pages vertically even after fixing the column width, repeating the header row on every page (rather than only on the first) makes the printed report far easier to read — this is a standard option in most Excel-to-PDF conversion tools and worth enabling for anything longer than a page.
Get your whole order sheet on one page, every column intact.