Printing Problems

Fix Wrapped Excel Text That Is Cut Off When Printing in WPS Office

Camila MilosovichCamila Milosovich Nov 13, 2026 868 views

Question details

The user needs to fix wrapped Excel text that looks correct on screen but is cut off when printing or previewing in WPS Office.

Fix Wrapped Excel Text That Is Cut Off When Printing in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
A user is printing an Excel worksheet in WPS Office Spreadsheets where wrapped text appears correctly on screen.
Observed behavior
The wrapped text is truncated in print preview or on paper.
Before you start

Open your worksheet in WPS Office Spreadsheets and note whether the wrapped text is cut off in Print Preview, printed output, or both. Confirm that Wrap Text is applied to the affected cells before changing printing settings.

Solution 1Recommended

Manually Set Row Heights to Fit Wrapped Text in WPS Office Spreadsheets

Use this first when the wrapped text appears correct on screen but is clipped in print preview or on paper.

Wrapped text can be cut off when the row height does not recalculate to match the printed font metrics. Setting an exact row height gives you direct control over how many wrapped lines are visible.

1
Select the rows that are cut off

Open the workbook in WPS Office Spreadsheets and click the row number at the left of each affected row. Hold Ctrl to select multiple rows.

2
Open the Row Height dialog

Right-click the selected rows and choose Row Height, or go to Home > Rows and Columns > Row Height in the toolbar.

3
Increase the row height and preview

Enter a taller value such as 30, 45, or 60 points, click OK, and open Print Preview to confirm every wrapped line is visible.

Manually Set Row Heights to Fit Wrapped Text in WPS Office Spreadsheets
Wrapped text now prints without being cut off: If one or two lines are still clipped, increase the row height slightly and preview again before printing.
WPS Office Spreadsheets printing fix

Print Wrapped Text Without Cut-Off Lines in WPS Office Spreadsheets

Make wrapped text print exactly as it appears on screen by adjusting row heights, print scaling, and page setup in WPS Office Spreadsheets. WPS Office is free, lightweight, and fully compatible with Microsoft Excel .xlsx files, so you can open, edit, and print the same workbook without losing formatting.

  1. 1. Open the workbook in WPS Office Spreadsheets: Double-click the Excel .xlsx file to open it in WPS Office, or open WPS Office and choose Spreadsheets > Open.
  2. 2. Select the rows with wrapped text: Click the row number at the left of the worksheet to select an entire row, then hold Ctrl and select additional affected rows.
  3. 3. Set an exact row height: Right-click the selected rows and choose Row Height. Increase the value so the full wrapped text is visible and click OK.
  4. 4. Adjust print scaling: Go to File > Print, open Scaling, and choose Fit All Columns on One Page or Fit Sheet on One Page.
  5. 5. Preview and print: Check the Print Preview, confirm every wrapped line is visible, and click Print.
Adjust row heights and print scaling directly in WPS Office SpreadsheetsOpens and saves Microsoft Excel .xlsx files without extra convertersFamiliar toolbar, print settings, and preview make switching from Excel easyFree and lightweight for daily spreadsheet editing and printing
microsoft office alternative - wps office

Frequently Asked Questions

Why does wrapped text print correctly on screen but cut off on paper in WPS Office?

WPS Office and the printer driver may calculate row heights differently when rendering for print. Select the wrapped rows, right-click and choose Row Height, then increase the height and check the result in File > Print preview.

How do I automatically fit row height to wrapped text in WPS Office Spreadsheets?

Select the affected rows and go to Home > Rows and Columns > AutoFit Row Height. If AutoFit does not make the rows tall enough, set a manual Row Height with a slightly larger value.

Will exporting to PDF fix my print problem?

Exporting to PDF does not fix the printer driver, but it helps diagnose the issue. Use File > Export > Export to PDF; if the PDF shows all text, update your printer driver or print to another printer.

Which print scaling option should I use to prevent cut-off text?

Open File > Print and choose Fit All Columns on One Page or Fit Sheet on One Page. This reduces or arranges the content so columns and rows stay inside the printable area.

Can merged cells cause wrapped text to be cut off when printing?

Yes. Merged cells often prevent AutoFit from recalculating row height correctly. Select the merged rows, set a manual Row Height, or avoid merging and use Center Across Selection from the alignment options.