How to Convert Excel to PDF on One Page (No Cut Columns)
Set the print area and page scaling in Excel before converting, using 'Fit Sheet on One Page' under Page Setup, since a PDF export follows Excel's own print settings. Skipping this step is why columns get cut off across separate pages.
Set the print area and scaling in Excel before converting, using Page Layout, then Page Setup, then "Fit to 1 page wide by 1 tall". A PDF export follows whatever print settings the spreadsheet already has, so a spreadsheet set up for normal printing without this adjustment is exactly why columns spill onto extra pages.
Why columns get cut off in the first place
Excel treats a PDF export the same way it treats printing to paper: it uses the sheet's page size, margins and scale settings to decide how much of the spreadsheet fits on each page. If a sheet is wider than one printed page at 100% scale, Excel splits the extra columns onto additional pages, which is exactly what shows up as "cut off" columns in the resulting PDF.
Step by step in Excel (desktop)
- Select the range of cells you actually want printed, or leave it blank to use the whole sheet.
- Go to Page Layout, then Print Area, then Set Print Area, if you only want a specific range.
- Go to Page Layout, then Page Setup (the small arrow in the corner of the group).
- On the Page tab, under Scaling, select "Fit to" and enter 1 page wide by 1 tall. To use the full width but allow as many pages as needed, type 1 in the wide box and leave the tall box blank.
- Switch to landscape orientation if your sheet is wider than it is tall, which usually fits more columns on one page at a readable size.
- Use Print Preview to check the layout before exporting, adjusting margins if anything still looks cramped.
- Export or save as PDF once the preview looks right.
If you would rather skip Excel's own settings, add the file directly to the Excel to PDF converter and use its fit-to-one-page option.
Excel to PDF, each sheet on one page
Sheet layout is set to Fit each sheet on one page. Switch to Normal if the text comes out too small.
Files are uploaded over HTTPS, processed and deleted from our server straight after. Open the full Excel to PDF page
Step by step with the FixDoks converter
- Open the Excel to PDF converter and add your XLS, XLSX, ODS or CSV file.
- Choose the option to fit each sheet on one page, if your spreadsheet has more columns than fit at normal scale.
- Convert and preview the result.
- Zoom in on the smallest text in the PDF to confirm it is still legible, since fitting more columns onto one page shrinks the text.
- Download the PDF once you are satisfied.
When shrinking to one page makes text too small
Fitting a very wide spreadsheet onto a single page can shrink text to the point of being hard to read, especially with many columns of dense data. If this happens, consider a few alternatives instead of forcing everything onto one page at an unreadable size:
- Fit to one page wide but allow more than one page tall, if the sheet has many rows but manageable columns.
- Hide columns that are not needed for this particular export, such as internal notes or helper calculations.
- Split a very wide sheet into a landscape, multi-page export instead of squeezing it onto one page, if readability matters more than a single-page result.
Always open and check the final PDF at actual size before sending it anywhere important, such as a report, invoice or official submission. A preview panel can look fine while the final export still has an issue with a specific row or a merged cell that renders unexpectedly.
Common mistakes
- Converting directly without adjusting Excel's print or page setup settings first, and then wondering why columns split across pages.
- Setting "Fit to 1 page" for both width and height on a sheet with many rows, which can shrink everything to an unreadably small size.
- Expecting manual page breaks to survive. Microsoft notes that Excel ignores manual page breaks when you use the Fit to option.
- Forgetting to set a print area, so the export includes empty columns or rows far beyond your actual data.
- Not checking merged cells or wrapped text, which can display differently in a PDF than in Excel's own on-screen view.
Headers, footers and repeating rows
If your sheet has column headers that should repeat on every printed page, set this under Page Layout, then Print Titles, before converting, so a multi-page export stays readable without the reader losing track of which column is which. This matters less when everything fits on a single page, but becomes important the moment a sheet spans two or more pages.
Other spreadsheet-to-PDF situations
The same page setup principles apply whether you are exporting a simple data table, an invoice template, or a report with charts. Charts and images anchored to specific cells can shift slightly when the scale changes, so always preview a sheet with charts particularly carefully before finalising the PDF. Browse the rest of the conversion tools if you regularly move files between Word, Excel, PDF and other formats.
Multiple sheets in one workbook
A workbook with several sheets converts each sheet using its own individual page setup, so a fit-to-one-page setting on one sheet does not automatically apply to the others. Check and adjust the page setup for every sheet you plan to include in the export, especially if some sheets are wider or narrower than others.
If you only need one specific sheet from a larger workbook, it is often simpler to select just that sheet's data range and export it on its own, rather than adjusting the settings for every sheet in a workbook you do not need in full.
Tools for this
Frequently asked questions
Why do my Excel columns get cut off when I save as PDF?
Because the PDF export follows Excel's existing print and page setup settings. If the sheet is wider than one printed page at its current scale, the extra columns spill onto additional pages, showing up as cut off content in the PDF.
How do I fit an Excel sheet onto one PDF page?
In Excel, go to Page Layout, then Page Setup, and choose 'Fit to 1 page wide by 1 tall'. Alternatively, use a converter with a built-in fit-to-one-page option so you do not have to adjust Excel's settings manually.
Will fitting everything on one page make the text too small to read?
It can, especially with many columns. If the result looks too cramped, consider allowing more than one page tall, hiding unnecessary columns, or accepting a multi-page landscape export instead.
Does this work for Google Sheets too?
Google Sheets has a similar print setup with scaling options under File, then Print, where you can choose 'Fit to width' before saving as a PDF.
Can I convert a CSV file the same way?
Yes, a CSV file can be converted to PDF using the same converter, though CSV files do not carry Excel-specific formatting like print areas, so the layout will follow the converter's own default or fit-to-one-page setting.
Sources
- Microsoft Support, Scale a worksheet (checked 2026-09)
- Microsoft Support, Fit to one page in Excel (checked 2026-09)
Rules and limits change. Always check the latest official notification or portal before you submit a form.