WPS Sheets Print Area Feature Usage Guide

Feature Summary

The Print Area feature is used to specify the range to be printed in a worksheet, avoiding printing the entire worksheet, saving paper and improving printing efficiency.

Feature Description

Operation Steps

Set Print Area

Feature Entry
"Page" tab → "Print Area" → "Set Print Area"

1. Select the cell range to print
2. Click the Page Layout tab
3. Click the Print Area button
4. Select Set Print Area
5. The selected range is marked as the print area

Add to Print Area

Feature Entry
"Page Layout" tab → "Print Area" → "Add to Print Area"

1. Select the cell range to add
2. Click the Print Area button
3. Select Add to Print Area
4. Multiple ranges will be printed on separate pages

Clear Print Area

Feature Entry
"Page Layout" tab → "Print Area" → "Clear Print Area"

1. Click the Print Area button
2. Select Clear Print Area
3. Restores printing of the entire worksheet

FAQ

Q1: What should I do if other content is still printed after setting the print area?

• Solution: Check if there are extra print areas, or select "Print Selection" in the print settings.

Q2: How can I view the current print area?

• Solution: In Page Break Preview view, the print area will be outlined with a blue border.

Notes

• Multiple print areas can be set for each worksheet
• Print area settings are saved with the document
• Clearing the print area will restore printing of the entire worksheet
• You can switch the desired print range in "Print Preview"