WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android

banner

Print the spreadsheet with different orientations and zoom percentages

Uploaded time: August 31, 2021 Difficulty Beginner

Print the spreadsheet with different orientations and zoom percentages

Print the spreadsheet with different orientations and zoom percentages

When using WPS Spreadsheet to print, we sometimes need to adjust the page orientation or the zoom ratio. How can we realize it?

Take this sheet as an example.

1. Click the Print Preview icon, then the Page Setup button.

2. Since the data is arranged downward, we can select Portrait to print the sheet in the corresponding orientation.

We can also adjust the zoom percentage in the Scaling category, since the entire spreadsheet is too large to print on one page.

Choose Fit to and choose Fit Sheet on One Page in the dropdown list. Then WPS Spreadsheet will automatically adjust the sheet to the appropriate size.

For more printing settings, choose theOthers...option from the dropdown list. Then we can set the accurate width and height of the page.

We can also assess quick settings for the printer, such as adjusting the size and quality of paper, and change the First-page number.

For example, if we don't want to start a print from the first page, click the First Page Number input box, and input the corresponding page number that you want it to start.

To be office excel advancers, we 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.