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


How to set the paper size of the table

Uploaded time: September 27, 2021 Difficulty Beginner

How to set the paper size of the table

How to set the paper size of the table

When printing tables in WPS Spreadsheet, to preview, we need to set the paper size first. So how can we set the paper size?

First, click the Page Layout tab above, and then click Size. WPS Spreadsheet has already provided us with a variety of paper sizes. We can click to preview.01.gif

If we need to adjust more settings for the paper size, we can click More Page Sizes. In the popup Page Setup dialog box, we can set Page Size and Print Quality according to different printers.In general, the higher the value of Print Quality, the higher the print resolution will be. After setting it up, click OK.02.gif

Finally, we click the Print Preview button to preview the effect of the table printed on the selected paper size.03.gif

Did you get it?

This skill could be also used in Microsoft Office Excel and Openoffice.

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