How to Print Only Selected Cells in an Excel Worksheet with WPS Office
Question details
The user needs to configure a print area in an Excel-compatible worksheet so only selected variable cells are printed, leaving preprinted invoice or form headings and static elements unchanged.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- A preprinted invoice or form already has static headings and layout on paper, and the user must print only the changing values from certain cells onto that form.
- Observed behavior
- The desired printed output includes only the variable cells, while preprinted headings and static form elements remain unchanged.
Open the target workbook in WPS Office Spreadsheets and locate the cells that contain the variable values. Make sure the paper form or invoice already has the static headings and layout printed, so the print area only needs to cover those variable cells.
Set a Print Area for Selected Variable Cells in WPS Office Spreadsheets
Use this to restrict the printout to only the cells that contain variable values on an invoice or preprinted form.
Open the Excel-compatible workbook in WPS Office Spreadsheets.
Click and drag to highlight only the cells containing the variable values that must appear on the printed form.
Go to the Page Layout tab, click Print Area, and choose Set Print Area.
Press Ctrl+P to open print preview, confirm only the selected cells appear, then click Print.
Change or Clear an Existing Print Area in WPS Office Spreadsheets
Use this when the variable fields move to a different range and the print area needs to be updated.
Print Selected Excel Cells with WPS Office Spreadsheets
Set a print area from selected cells in WPS Office Spreadsheets to print only variable data on preprinted forms while keeping the static layout unchanged.
- 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office, open the Excel-compatible workbook containing the invoice or form.
- 2. Select the variable cells to print: Click and drag to highlight only the cells whose values should appear on the printed form.
- 3. Set the print area: Go to the Page Layout tab, click Print Area, and choose Set Print Area.
- 4. Preview and print: Press Ctrl+P to open print preview, confirm only the selected cells appear, then select your printer and click Print.
Frequently Asked Questions
Will setting a print area change anything on my preprinted form?
No. The print area only controls which worksheet cells are sent to the printer. The preprinted headings or static form elements already on the paper remain unchanged, and no worksheet data is permanently changed.
How do I update the print area when my variable cells move?
Go to the Page Layout tab, click Print Area, choose Clear Print Area, then select the new variable cells and click Print Area > Set Print Area.
Does this work in WPS Office when my workbook was created in Microsoft Excel?
Yes. Open the .xlsx workbook in WPS Office Spreadsheets, set the print area as usual, and the workbook remains Excel-compatible.
Why does my printout still include extra cells after setting the print area?
Make sure the previous print area was cleared or reset, confirm the selected range only covers the intended cells, and check the print preview before printing.
