Print the spreadsheet with different orientation and zoom percentage

Uploaded time: 2021-08-31 Difficulty: Primary

Print the spreadsheet with different orientation and zoom percentage

Print the spreadsheet with different orientation and zoom percentage

Graphic skills

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. 

GIF.gif

 

For more printing settings, choose the Others... 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.

GIF_1.gif


To be office excel advancers, we could learn how to use WPS Office Spreadsheet online in WPS Academy.