Printing Problems

Fix WPS Office Excel PDF Export Cropping on an External Monitor

Elise WilliamsElise Williams Nov 13, 2026 869 views

Question details

The user needs to prevent a chart from being partially cut off when exporting a WPS Office Excel worksheet to PDF while the workspace is displayed on an external monitor.

Fix WPS Office Excel PDF Export Cropping on an External Monitor
Product
WPS Office Excel
Device & OS
not provided
Scenario
The user is exporting an Excel worksheet containing a chart to PDF while Excel is displayed on an external monitor and wants the full chart included.
Observed behavior
The chart is partially cut off in the exported PDF, likely due to display scaling, resolution, print area, or page setup settings.
Before you start

Before changing settings, connect the external monitor and open the affected workbook in WPS Office Excel. Note the current display scaling in Windows and the page layout settings in the workbook so you can compare changes.

Solution 1Recommended

Adjust Print Area, Page Setup, and Fit Sheet on One Page

Use this solution first when the chart looks correct on screen but is cut off in the PDF because the chart is outside the printable area.

WPS Office Excel uses the current page setup and print area when exporting to PDF. If the chart extends outside the printable area, the PDF export can crop it even though the chart looks fine on screen.

1
Open the Print Area dialog

In WPS Office Excel, select the affected worksheet, go to Page Layout > Print Area > Set Print Area, and make sure the entire chart is inside the selected range.

2
Set page orientation and margins

Go to Page Layout > Orientation and Size, then click Margins and choose Narrow or Custom Margins to give the chart enough space.

3
Apply Fit Sheet on One Page scaling

Open Print Preview, go to Page Setup > Scaling, select Fit Sheet on One Page, and confirm the full chart is visible before exporting.

4
Export the workbook to PDF

Click File > Export to PDF, choose a save location, and open the PDF to verify that the chart is no longer cropped.

Adjust Print Area, Page Setup, and Fit Sheet on One Page
Chart stays inside the printable area: After applying these settings, the chart should remain within the printable area and appear complete in the PDF.

Export WPS Office Excel to PDF Without Cropping Charts on an External Monitor

Use WPS Office Excel's page setup, print area, and scaling controls to keep the entire chart inside the printable area before exporting to PDF, so external monitor scaling does not crop the output.

  1. 1. Open the workbook in WPS Office Excel: Launch WPS Office, open the affected .xlsx workbook, and switch to the worksheet that contains the chart.
  2. 2. Define the print area: Go to Page Layout > Print Area > Set Print Area and select the range that includes the full chart and any data you need in the PDF.
  3. 3. Configure page setup: Click Page Layout > Size, Orientation, and Margins, and choose settings that keep the chart inside the printable area.
  4. 4. Apply Fit Sheet on One Page: Open Print Preview, click Scaling, select Fit Sheet on One Page, and confirm the entire chart appears in the preview.
  5. 5. Export to PDF: Click File > Export to PDF, choose the location, and open the PDF to verify the chart is no longer cut off.
Keeps charts and print areas intact when exporting Excel workbooks to PDFFully compatible with Microsoft Excel .xlsx, .xls, and PDF export workflowsLightweight page setup and PDF export tools that work across multiple monitorsFree alternative to Microsoft Office with familiar ribbon tools
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Excel chart get cut off when I export to PDF on an external monitor?

It usually happens because display scaling or resolution changes how Excel calculates the visible area, while the page setup or print area still uses a different printable area. Check the external monitor scaling and set the print area and Fit Sheet on One Page before exporting.

How do I stop WPS Office Excel from cropping the chart when exporting to PDF?

Set the print area around the full chart, choose appropriate page orientation and margins, and use Fit Sheet on One Page in Print Preview. Then use File > Export to PDF.

Will moving Excel to the laptop screen fix PDF cropping?

Often yes. Drag the Excel window to the primary display, restart Excel, and export again. If the PDF is complete, the issue is likely the external monitor scaling or driver.

What display scaling should I use for an external monitor when exporting Excel to PDF?

Use a standard Windows scaling value such as 100% or 125% on the external monitor. Open Settings > System > Display, select the monitor, and change scaling before retesting the export.

Do I need to update drivers for Excel PDF cropping issues?

Not always, but outdated display drivers can contribute to scaling and resolution problems. Open Device Manager > Display adapters, right-click the adapter, and choose Update driver, then restart if required.