Print page setup in WPS Spreadsheet

Uploaded time: September 30, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

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.