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 print scaling

Uploaded time: September 27, 2021 Difficulty Beginner

How to set the print scaling

How to set the print scaling

We want to print the table on one page, but the table is too large. It is divided into several pages when printed. Then, how can we do? The print scaling feature of WPS Presentation can help you solve this problem quickly.

Take this document as an example. We can see that without scaling, the table will be divided into four pages for printing. Just click the Page Layout tab above, then Page Zoom, and finally click Fit Sheet on One Page. In this way, the table will automatically adapt to the scaling and print on one page.01.gif

In addition, in the Page Zoom drop-down menu, we can choose Fit All Columns on One Page or Fit All Rows on One Page. We can also adjust the zoom ratio of the page to the actual situation.02.gif

After setting the zoom ratio, click Print Preview to preview the print effect in advance. We can also set page zoom in the upper right corner of the preview interface.03.gif

What a practical feature!  Did you get it? To be office excel advanced, you could learn how to use WPS Office Spreadsheet online in WPS Academy.

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