WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


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


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Print page setup in WPS Spreadsheet

Uploaded time: September 30, 2021 Difficulty Beginner

Print page setup in WPS Spreadsheet

Print page setup in WPS Spreadsheet

When we need to print a table, if we are not satisfied with the effect of the currently displayed page, how can we quickly set up the page?

Take this table as an example. Click Print Preview in the quick access toolbar to enter the print preview interface. Click the Page Setup button, then the Page Setup dialog box will pop up.

In the Page tab, we can adjust the Orientation and Scaling of the page and the related settings of the printer.

In the Margins tab, we can precisely adjust the size of the page margins and the position of the header and footer. We can also choose the Center on page of the table.

In the Header/Footer tab, we can set the header and footer in the printed page.

In the Sheet tab, since we have selected to print all table areas, the Print area here cannot be set. In this dialog box, we can choose whether we need to print out Gridlines, Comments, and so on. In addition, we can setPage order.

Make your work easier with WPS Spreadsheet like Microsoft Excel.For a detailed tutorial on page setup, you're welcome to WPS Academy.  

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