How to Fix Excel Columns Cut Off When Converting to PDF
Question details
The user needs to prevent characters at the end of Excel columns from being cut off or missing when converting the spreadsheet to a PDF file.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Converting an Excel spreadsheet to a PDF document for sharing or printing without losing data.
- Observed behavior
- Characters at the end of columns are missing in the resulting PDF, even though the spreadsheet and initial print preview appear correct.
Before adjusting your settings, ensure that your Excel document is saved and that you have a dedicated PDF printer installed on your system.
Change Printer to PDF and Adjust Scaling
Selecting the PDF printer before previewing and fixing unintended scaling percentages resolves most document reflow issues.
Excel often reflows documents based on the default physical printer's margins and resolution capabilities. By switching to a PDF printer first, you force Excel to render the layout exactly as it will appear in the final PDF document.
Go to File > Print in your Excel workbook. Under the Printer dropdown menu, select your PDF printer (e.g., Adobe PDF) instead of your default physical printer.
Click on the Page Setup link located at the bottom of the print settings menu.
On the Page tab, check the Scaling section. Ensure it is set to 'Adjust to: 100% normal size', or choose 'Fit to: 1 page(s) wide' if you need to force all columns onto a single page.
Check the Print Preview on the right side of the screen to ensure no columns are cut off, then click the Print button to generate your PDF.
Manually Adjust Column Widths and Row Heights
If scaling adjustments leave extra spaces or cut off text due to font rendering differences, manual column adjustments may be necessary.
Use WPS Office for Flawless Excel to PDF Conversions
WPS Office provides a built-in, highly accurate PDF converter that prevents layout shifts, scaling issues, and cut-off columns without the need to configure third-party virtual printers.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open the file you want to convert.
- 2. Select Export to PDF: Click on the Menu button in the top left corner and select Export to PDF.
- 3. Configure export settings: In the export dialog, choose your desired save location. Click the Advanced settings button if you need to adjust margins or ensure all columns fit on one page.
- 4. Export the file: Click the Export button to instantly create a perfectly formatted PDF without cut-off text.
Frequently Asked Questions
Why does my Excel file look different in Print Preview than in the normal view?
Excel relies on your currently selected printer's driver to render the Print Preview and calculate cell dimensions. If your default physical printer has different margin limits or resolution capabilities than your screen, the layout will shift or reflow when previewed or printed.
How do I force an Excel sheet to fit on one PDF page?
Go to File > Print, click Page Setup, and under the Page tab, select 'Fit to 1 page(s) wide by 1 tall'. This automatically scales your columns to prevent them from extending past the page boundary and being cut off.
Does the DPI setting affect Excel to PDF conversion?
Yes, mismatched DPI (Dots Per Inch) settings between Excel's Page Setup and the virtual PDF printer properties can cause text scaling issues. This often results in characters at the end of a column being cut off. Ensuring both are set to the same value, such as 600 DPI, resolves this conflict.
