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.
Windows • MacOS • Linux • iOS • Android
Print page setup in WPS Spreadsheet
Uploaded time: September 30, 2021 Difficulty Beginner
Print page setup in WPS Spreadsheet
![](http://res-academy.cache.wpscdn.com/static/cover/big_xls.png)
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.
Also Read:
- 1. Page setup and print-out for spreadsheets
- 2. How to insert Page Break in WPS Spreadsheet
- 3. How to insert a background image and print it out in WPS Spreadsheet
- 4. Print the spreadsheet with different orientations and zoom percentages
- 5. Set the page printing area in WPS Office Spreadsheet
- 6. Instructions of page setup in worksheet
Does this video help you?