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

Tips: you can turn on the volume by clicking

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.

1 (1).gif


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

1 (2).gif


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.

1 (3).gif


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

1 (4).gif


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 set Page order.

1 (5).gif


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