Convert Excel to PDF Without Cutting Off Columns (Print Settings + Quick Fixes)

“Excel to PDF” sounds simple until the PDF comes out wrong: the last column is missing, the header row disappears, or the text gets shrunk into unreadable micro-fonts.

The fix is usually not a different converter—it’s your Excel print settings. Once the sheet is set up to print the way you want, converting is straightforward.

Quick answer (featured snippet)

To convert Excel to PDF without cutting off columns:

1. In Excel, go to Page Layout → Orientation and choose Landscape if the sheet is wide.
2. Set the printable range with Page Layout → Print Area → Set Print Area.
3. Open Page Layout → Scale to Fit and set:
   • Width: 1 page
   • Height: Automatic (or 1 page if you need a single-page PDF)
4. Use File → Print and check the preview. Adjust margins if needed.
5. Convert your .xls/.xlsx with Dogufy’s Excel to PDF tool and download the PDF.

If the print preview looks correct, the PDF conversion almost always looks correct too.

Why columns get cut off in Excel-to-PDF conversions

Most converters (including Excel itself) generate the PDF based on your worksheet’s print layout, which includes:

• Page size (A4 vs. Letter)
• Margins
• Orientation (Portrait vs. Landscape)
• Scaling (Fit to page vs. “No scaling”)
• Print area (what Excel is allowed to print)

If any of these are off, the PDF will reflect that—often by clipping the right edge of the sheet or pushing columns onto an extra page.

Step 1: Set up your sheet to print cleanly (the checklist)

These are the fastest settings to check when your PDF looks “cut off”.

1) Pick the right orientation (Portrait vs. Landscape)

If you have more than a few columns, start with Landscape:

• Page Layout → Orientation → Landscape

Portrait can work for narrow tables, but it’s the most common reason wide sheets get clipped.

2) Set the print area (so Excel prints the right range)

If Excel prints blank space (or skips part of your table), set a print area:

1. Select the cells you want in the PDF (your table + header row).
2. Go to Page Layout → Print Area → Set Print Area.

Tip: If you previously set a print area and forgot, it can cause weird “missing columns” behavior. Clear it with Page Layout → Print Area → Clear Print Area, then set it again.

3) Fit wide sheets to one page (without guessing)

This is the highest-impact fix for “last column cut off”:

1. Go to Page Layout → Scale to Fit.
2. Set Width: 1 page.
3. Leave Height: Automatic if you don’t mind the table continuing onto multiple pages.

This keeps all columns on the page width, while letting rows flow naturally.

If you force both Width: 1 and Height: 1, Excel will compress everything to a single page—which can make text too small.

4) Choose page size (Letter vs. A4)

If your PDF will be printed or uploaded to a portal that expects a specific standard, match the page size:

• Page Layout → Size → Letter / A4

This avoids surprise reflow when someone prints it later.

5) Adjust margins when a single column won’t fit

If you’re “just barely” clipping the last column, margins can be the difference:

1. Open File → Print.
2. Set Margins → Narrow (or Custom Margins).
3. Re-check the preview.

6) Repeat the header row on every page (so PDFs are readable)

For multi-page tables, repeating headers prevents confusion:

1. Page Layout → Print Titles
2. In Rows to repeat at top, select your header row (often $1:$1).

Step 2: Convert Excel to PDF with Dogufy

Once the print preview looks right, converting takes a minute:

1. Open Dogufy’s Excel to PDF tool.
2. Upload your .xls or .xlsx file.
3. Click Convert to PDF.
4. Download the generated PDF and quickly spot-check:
   • the last column
   • header rows
   • page breaks

If something looks off, go back to Excel, adjust the print setup, and convert again.

Common problems (and the quickest fixes)

“The last column is still missing”

Try these in order:

1. Set Width: 1 page (Scale to Fit).
2. Switch to Landscape.
3. Reduce margins (Narrow).
4. Slightly reduce the font size or column widths (Excel layout changes can ripple).

“The PDF is readable, but the text is too small”

This usually happens when the sheet is being forced to a single page.

• Keep Width: 1 page but set Height: Automatic.
• Consider splitting the table into two sections (e.g., hide non-essential columns or move them to a second sheet).

“Some rows/columns are blank in the PDF”

Check the print area:

• Page Layout → Print Area → Clear Print Area
• Re-select the table and Set Print Area again

Also verify filters: filtered-out rows may not appear depending on how the sheet is structured.

“My PDF is multiple worksheets, but I only need one”

Export or isolate only what you need:

• Duplicate the workbook and keep only the target sheet, then convert.
• Or convert the full file and extract pages afterward using Split PDF.

“I have multiple Excel files and want one combined PDF”

A simple workflow:

1. Convert each spreadsheet with Excel to PDF.
2. Combine the resulting PDFs using Merge PDF.

This is also a clean way to build a single “report pack” from separate exports.

“The PDF file size is too big to email/upload”

After converting, reduce the size using Compress PDF.

Tip: If your spreadsheet contains large images (logos, photos, screenshots), compressing is especially effective.

Best-practice workflow (so you don’t redo work)

If you convert Excel to PDF frequently (weekly reports, invoices, statements), save yourself time with this repeatable routine:

1. Set up one “master” sheet with the right print area, orientation, and scaling.
2. Paste new data into the same layout each time.
3. Confirm the print preview.
4. Convert using Excel to PDF.

This keeps your PDFs consistent—and avoids the “why did page 2 suddenly change?” problem.

FAQ

Does this work with .xls and .xlsx?

Yes—Dogufy’s tool supports both .xls and .xlsx. If you have the option, .xlsx is the more modern format and tends to behave more consistently across tools.

Why does the PDF layout change when I send it to someone else?

A PDF is a fixed layout, but printing it can vary if the recipient uses different paper size defaults (Letter vs. A4) or printer settings. To minimize surprises, pick the correct Page Layout → Size before conversion.

Can I convert Google Sheets to PDF with Dogufy?

If you can download your sheet as an Excel file (.xlsx), you can then convert it with Excel to PDF.

Can I edit the PDF after converting?

If you need to add text, highlights, or annotations to the PDF after conversion, use Edit PDF.