Set the page printing area in WPS Office Spreadsheet

What should we do when we print a spreadsheet if we want to print a certain area of it? This video could help to solve the problem and could be also used in Microsoft Office Excel and Openoffice. Take this spreadsheet as an example. If we want to print the student ID, and their Chinese and mathematics scores, select this cell area, click the Page Layout tab and the Print Area drop-down button, and select Set Print Area to set the selected area as a printable area. Click Print Preview i....

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....

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 ....

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.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 hi....

Print the spreadsheet with different orientation and zoom percentage

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 Fi....

Instruction of page setup in worksheet

When printing WPS Spreadsheet, in order to print out the table more readable and more beautiful, we can set up the printed page of the table. Take this table as an example. First, click the Page Layout tab and then click the Print Titles button to enter the Page Setup dialog box. If we want to print a specific part of the area, select the area that needs to be printed in the Print area box. If we want to print too much data, we can print them on several pages. Except for the first pag....

How can we set header and footer

A formal form usually has additional information such as the company’s logo, time, and page number at the top or bottom. This specific area is called header and footer. Do you know how we can set it? Take this table as an example. Get into the Insert tab first, and then click Header/Footer. You can also click the Header and Footer button in the Print Preview tab to set the header and footer area.After the page setting dialog box pops up, we can now see that WPS has already built in som....

Create an area chart to display data trends

Do you know how to make an ordinary line chart more special? Today we are going to show you how to make a line chart with fill effects, that is, an area chart.Take this table as an example. This is the dynamic price-earnings ratio data of a certain country over a period of time. It is difficult for us to see the difference between the data. Therefore, we need to use an area chart to show the changes in the dynamic price-earnings ratio index.1. First, we click the Insert tab.2. Click th....