WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Set the page printing area in WPS Office Spreadsheet

Uploaded time: August 27, 2021 Difficulty Beginner

Set the page printing area in WPS Office Spreadsheet

Set the page printing area in WPS Office Spreadsheet

What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice.

Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores,select this cell area,click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. 

111_01.gif

Click Print Preview in the quick access toolbar to view the print effect.

111_2.gif

 If we want to cancel the print area, click the Print Area drop-down button, and choose Clear Print Area.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.