How to Convert Excel to PDF Without Cutting Off Columns

Converting an Excel spreadsheet to PDF is useful when sharing reports, financial summaries, schedules, and tables that recipients should be able to view without editing.

However, one of the most common problems is that columns get cut off or appear on separate pages.

A spreadsheet that looks perfect in Excel may become difficult to read after conversion.

Fortunately, most of these issues can be resolved by adjusting page layout, print area, scaling, and paper size before exporting.

This guide explains how to convert Excel to PDF while keeping your tables readable and properly organized.

Why Does Excel Cut Off Columns When Converting to PDF?

Excel spreadsheets are designed around a flexible grid of rows and columns.

Unlike a Word document, a worksheet does not have a fixed page boundary while you're editing it.

A worksheet can extend across hundreds of columns and thousands of rows.

PDF documents, however, use defined page dimensions.

When Excel exports a worksheet to PDF, it must divide the spreadsheet into printable pages.

If the worksheet is wider than the selected paper size, Excel may:

• Split columns across multiple pages
• Scale the worksheet down
• Create additional pages
• Leave large blank areas
• Cut off content outside the print area

The solution is to control how the worksheet fits onto PDF pages.

Method 1: Convert Excel to PDF Using Microsoft Excel

Microsoft Excel provides detailed page layout and printing options.

These settings are especially useful for spreadsheets containing wide tables.

Step 1: Open Your Excel Spreadsheet

Open the workbook in Microsoft Excel.

Select the worksheet you want to convert.

Review the data and make sure that all required rows and columns are visible.

Step 2: Set the Page Orientation

Go to Page Layout > Orientation.

Choose between:

• Portrait: Suitable for narrow tables and vertical reports.
• Landscape: Better for wide spreadsheets containing many columns.

For most wide tables, landscape orientation is a useful starting point.

Step 3: Choose the Paper Size

Go to Page Layout > Size.

Select the appropriate paper size, such as A4 or Letter.

The paper size affects how many columns fit on each page.

Step 4: Adjust the Scaling Settings

In the Page Layout tab, locate the scaling options.

To fit all columns onto one page, try:

• Width: 1 page
• Height: Automatic

This setting attempts to fit the worksheet width onto a single page while allowing rows to continue onto additional pages.

Forcing both width and height to one page may make large spreadsheets unreadably small.

Step 5: Set the Print Area

If you only need to export part of the worksheet, select the relevant cells.

Go to Page Layout > Print Area > Set Print Area.

This helps prevent unrelated data or empty areas from appearing in the PDF.

Step 6: Preview the Pages

Choose File > Print to open the print preview.

Review the page boundaries carefully.

Check whether:

• All columns are visible
• Text remains readable
• Tables are split logically
• Headers appear correctly
• Blank pages are present

Step 7: Export as PDF

Choose File > Save As or File > Export, depending on your Excel version.

Select PDF as the output format.

Save the file and open it to verify the result.

Method 2: Convert Excel to PDF Online

An online converter can be useful when you need to create a PDF without opening the spreadsheet in Microsoft Excel.

Step 1: Open PDFreevert

Visit PDFreevert and locate the Excel to PDF tool.

Step 2: Select Your Spreadsheet

Choose the spreadsheet file you want to convert.

Before uploading, check that the workbook contains the correct data and formatting.

Step 3: Prepare the Workbook

If possible, configure the worksheet's page layout in Excel or another compatible spreadsheet application before uploading.

Important settings include:

• Page orientation
• Paper size
• Print area
• Scaling
• Page breaks

These settings may influence how a converter renders the workbook.

Step 4: Convert the Spreadsheet

Follow the converter's instructions to create the PDF.

Step 5: Review the PDF

Download the result and check every page.

If columns are cut off, revise the spreadsheet's page layout settings and try again.

How to Fit All Excel Columns on One PDF Page

One of the most useful Excel features is the ability to control page scaling.

For a worksheet with many columns, use the following approach.

Fit Width to One Page

Set the page width to one page while allowing the height to remain automatic.

This keeps columns together while permitting long tables to span multiple pages vertically.

Use Landscape Orientation

Landscape orientation provides more horizontal space.

It is especially helpful for financial reports, inventory lists, and wide tables.

Reduce Unnecessary Column Widths

Sometimes, columns are wider than necessary because of long headings or excessive spacing.

Review column widths and remove unused columns before exporting.

Adjust Margins

Narrower margins can create additional room for the spreadsheet.

However, avoid margins that are too small for the intended printer.

Use Larger Paper Sizes When Appropriate

For unusually wide tables, a larger page size such as A3 may be more suitable.

Keep in mind that recipients may not have access to printers supporting larger paper sizes.

Why You Shouldn't Always Fit Everything on One Page

It may seem convenient to fit an entire spreadsheet onto one PDF page.

However, this can make the text extremely small.

For example, a worksheet with 25 columns and 200 rows may technically fit onto a single page, but the result could be impossible to read.

A better approach is to fit the columns across one page while allowing rows to continue onto additional pages.

The goal should be readability, not simply minimizing the number of pages.

Common Excel-to-PDF Problems

How to Repeat Column Headers on Every PDF Page

Long spreadsheets often contain multiple pages of data.

Without repeated headers, readers may have difficulty understanding the columns on later pages.

In Excel, you can configure print titles.

Step 1: Open Page Layout

Select the worksheet and go to Page Layout.

Step 2: Select Print Titles

Open the Print Titles settings.

Step 3: Choose Rows to Repeat

Specify the header rows that should appear at the top of each printed page.

For example, you might repeat the first row containing column names.

Step 4: Preview and Export

Check the print preview to confirm that headers appear correctly.

Then export the worksheet to PDF.

Frequently Asked Questions

How do I convert Excel to PDF without cutting off columns?

In Excel, set the page orientation to landscape if needed, then configure scaling so the worksheet width fits onto one page. Check the print preview before exporting.

Why is my Excel PDF split into multiple pages?

The worksheet may be larger than the selected paper size. Excel divides it into printable pages according to page layout and scaling settings.

How can I convert Excel to PDF without making the text too small?

Fit the worksheet width to one page, but allow the height to span multiple pages. Avoid forcing an entire large worksheet onto a single page.

Can I export only selected Excel cells to PDF?

Yes. In Microsoft Excel, you can define a print area containing the cells you want to include.

How do I keep table headers on every page?

Use Excel's Print Titles feature to repeat selected header rows on each printed page.

Conclusion

Converting Excel to PDF without cutting off columns requires more than simply selecting a different file format.

Page orientation, paper size, scaling, print area, and page breaks all affect the result.

For wide spreadsheets, start by using landscape orientation and fitting the worksheet width onto one page.

Always review the print preview and final PDF before sharing important reports.

If you prefer a browser-based workflow, explore the Excel to PDF conversion tools available on PDFreevert.