When an Excel sheet looks fine on screen but the PDF cuts off columns, the problem is usually the worksheet’s print layout—not the PDF itself. Excel converts the configured print area, paper size, orientation, margins, and scaling into pages. A wide sheet can therefore spill onto a second page or become unreadably small if you force everything onto one page.
Start with Print Preview
Open File → Print before exporting. This preview is the fastest way to see where Excel plans to break the worksheet. If columns appear on a second page, fix the page setup before creating the PDF.
Fit all columns on one page
- Open Page Layout.
- Under Scale to Fit, set Width to 1 page.
- Leave Height on Automatic if the sheet has many rows.
- Switch to Landscape when the worksheet is wide.
- Check Print Preview again.
Microsoft recommends fitting the width to one page when you want all columns together while allowing rows to continue across multiple pages. Forcing both width and height to one page can shrink a large worksheet so much that it becomes difficult to read.
Check the print area
An old or accidental print area can make the PDF include empty columns, omit data, or add blank pages. Select only the range you actually need, then use Page Layout → Print Area → Set Print Area. If a print area is already set incorrectly, clear it first.
Use the right paper size and margins
Confirm whether the final document should be A4, Letter, or another size. A paper-size mismatch can change page breaks. Narrow margins can also give wide tables more usable space, but keep enough margin for comfortable reading and printing.
Do not solve every problem with extreme scaling
If the preview becomes tiny, reduce unnecessary columns, use landscape orientation, choose a larger paper size, or let the sheet continue vertically. A readable two-page PDF is often better than a one-page PDF that requires heavy zooming.
Convert and verify
After the preview looks correct, export the workbook to PDF. Open the PDF and check the first page, last page, column headers, totals, and any charts. If you already have an XLSX file ready, you can also use the RevifyHub Excel to PDF tool and then verify the output.
Common mistakes
- Using “Fit Sheet on One Page” on a very large worksheet.
- Leaving an old print area active.
- Exporting in Portrait when the table is clearly wider than it is tall.
- Using Letter in one step and A4 in another.
- Skipping Print Preview before conversion.
If columns are still missing
Temporarily remove scaling and inspect the natural page breaks. Also check for hidden columns, merged cells, very wide objects, charts, or shapes outside the main table. These can expand the printable range even when the visible data looks normal.
Bottom line
Fix the Excel page layout first: set the correct print area, fit the sheet to one page wide, choose the right orientation and paper size, and confirm everything in Print Preview. Then create the PDF and verify it once more.
Reference: Microsoft Support: Fit to one page in Excel.