Skip to content

How to convert Excel to PDF and fit every column on the page

By the Fusion Office team · Updated

Quick answer

Excel to PDF uses the print area and page setup saved in your workbook, so wide sheets split across pages the way Excel would print them. To keep every column on one page, set the sheet to Landscape and Fit All Columns on One Page in Excel's page setup, save, then convert.

Set up the sheet in Excel

  1. 1Select the cells to print and choose Page Layout → Print Area → Set Print Area.
  2. 2Set Orientation to Landscape for wide tables.
  3. 3Under Page Layout → Scale to Fit, set Width to 1 page and Height to Automatic (or choose Fit All Columns on One Page in the print settings).
  4. 4Optionally repeat the header row on each page: Page Layout → Print Titles → Rows to repeat at top.
  5. 5Save the workbook.

Convert

  1. 1Open Excel to PDF and choose the .xlsx, .xls, .ods or .csv file.
  2. 2Press Convert to PDF.
  3. 3Download and check that every column is on the page.

Every sheet in the workbook is converted. The file is converted on our server and deleted as soon as the PDF is ready.

Simple tables without Excel

For a plain table, CSV to PDF with Landscape on gives a clean, printable table with the header row repeated on every page, without any page setup. Very wide sheets with dozens of columns may still be too small to read on one page; split them into two tables instead.

Frequently asked questions

Why is my PDF blank or missing sheets?

Check the print area: an old print area may cover only part of the sheet. Clear it in Page Layout → Print Area → Clear Print Area.

Can I convert just one sheet?

Save a copy of the workbook with only that sheet, or convert the whole file and delete the other pages afterwards.