Why Columns Get Cut Off in the First Place
When Excel converts a spreadsheet to PDF, it treats each page like a sheet of paper. If your data is wider than the page, the extra columns get pushed to a new page — or worse, silently dropped.
The root causes are almost always one of these:
- 1.Page width is too narrow. Portrait mode on letter-size paper only fits about 8-10 standard columns. If you have 15 or 20 columns, the rest overflow.
- 2.No print area is set. Without a defined print area, Excel guesses which cells to include. It often includes empty columns or misses the columns you need.
- 3.Hidden margins are eating space. Default margins in Excel (0.7" on each side) steal 1.4 inches of usable width. That's enough to lose 2-3 columns.
- 4.Column widths are uneven. One extra-wide column (like a "Notes" or "Description" column) can push everything else off the page.
5 Fixes for Cut-Off Columns
Fix 1: Set Your Print Area
This is the single most important step and fixes the problem in most cases.
- Select all the cells you want in your PDF (click and drag from the first cell to the last)
- Go to Page Layout → Print Area → Set Print Area
- Check with Print Preview (Ctrl+P) to verify all columns appear
Once the print area is set, convert using OmnisPDF's Excel to PDF tool.
Fix 2: Switch to Landscape Mode
Landscape orientation gives you roughly 40% more horizontal space — often enough to fit those extra columns.
Go to Page Layout → Orientation → Landscape. For most spreadsheets with 10-15 columns, this alone solves the problem.
Fix 3: Scale to Fit One Page Width
This is Excel's built-in scaling feature that shrinks everything proportionally to fit on one page width.
Go to Page Layout → Scale to Fit → Width: 1 page. Leave Height set to "Automatic" so rows can flow to multiple pages.
Warning: If you have 30+ columns, the text might become too small to read. In that case, use Fix 5 instead. Read more about optimal scaling in our fit-to-page guide.
Fix 4: Reduce Margins
Default margins are generous. Narrowing them can give you enough room for 2-3 extra columns.
Go to Page Layout → Margins → Narrow (sets 0.25" margins). For maximum space, choose Custom Margins and set all margins to 0.2".
Fix 5: Split Wide Sheets Into Sections
If your spreadsheet is genuinely wide (20+ columns), sometimes the best approach is to split it into two logical sections.
Copy columns A-J to one sheet and columns K-T to another. Convert the entire workbook — each sheet becomes a separate page in the PDF.
After converting, if you need to reorganize the pages, use Split PDF to separate or reorder them.
Pre-Conversion Checklist
Run through this checklist before converting any Excel file to PDF:
- ✓ Print area is set to include all needed columns and rows
- ✓ Orientation is correct — landscape for wide sheets, portrait for tall ones
- ✓ No "###" cells — all columns are wide enough to display their data
- ✓ Print Preview confirms all columns are visible (Ctrl+P or Cmd+P)
- ✓ Scale is readable — text isn't shrunk below 8pt font
Still Having Issues?
If columns are still getting cut off after trying these fixes, the issue might be with the conversion tool you're using. Desktop Excel handles page breaks differently than online converters.
Try converting with OmnisPDF's Excel to PDF tool — it uses server-side rendering that closely matches Excel's own output. You can also try our general Office to PDF converter for additional format support.