Print page setup in WPS Spreadsheet

Uploaded time: September 30, 2021 Difficulty: Primary

Print page setup in WPS Spreadsheet

Print page setup in WPS Spreadsheet

Tips: After starting to play, you can adjust the video clarity, click

Quality

Auto 720p

Graphic skills

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.