Download WPS Office for your device

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

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

In this lesson, we learned about the basic use of line and area charts.1.A line chart and an area chart are essentially identical. Both may effectively display data trends over a specific time period, but an area chart is better for displaying the stacked effect.2.The combo of a line chart and an area chart can diversify the data. The right color scheme can make the chart more advanced.3.In the same chart, a combo of line and column charts can display two sets of data with different di....

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

We may add notes to important content when reading a PDF document. Do you know how to print them out?Take this document as an example. We have added several notes on the page. 1. Click Menu and click Print.2. On the right of the pop-up dialog, select Document and Note Contents in the "Print content" drop-down button.3. Then the marks of notes are displayed in the preview window. However, we still fail to print out the contents in the text boxes. What can we do? There are two methods fo....

When using WPS Writer for typesetting, we often need to adjust the spacing between characters. How can we adjust the character spacing?Take this document as an example. Select the text content, click Home in the upper menu bar, and choose Settings → Font. Then we can see the Font window. We can also press the shortcut key Shift+D to pop up the dialog. Get into the Character Spacing tab, and change the setting of Spacing. Here, we can choose one of the three default character spacing e....

Adding bullets to the text content can play a role in highlighting and make our slides look more layered. So, how can we add bullets? Select the text content that needs to be added with bullets, click the Home tab above, and then click the Bullets button. Here, we can see the various preset bullets animations provided by WPS. We can also set the color and size of the bullets as needed.If there is no required bullet, we can click Bullets first and then click More Bullets. In the pop-up ....

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