Download WPS Office for your device

WPS Spreadsheet could be an alternative to Microsoft Office Excel. It includes 100's of built-in formulas, pivot tables, and more. When we meet a situation where a large amount of data in the table can not be completely displayed in the window, we still want to see the contents from different positions at the same time. To solve this, using the Split window is probably the best idea. If you want to connect the total sales with Branch in a spreadsheet with massive data, dragging the....

After modifying the document, we can compare it with the original document and generate the revised document if we want to view the modification trace. Next, I will show you how to use the comparison function through a case. Take "Document 2" as an example. Click the Review tab and the Compare drop-down button, and choose Compare. Then, a dialog box will pop up. In the Original document box, select "Document 1". In the Revised document box, select "Document 2". In the Label changes wit....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Do you still jump back and forth between two documents when you need to compare the revision between them? At this time, we can place the two documents in the same interface with the help of View Side by Side. Let's take these two documents as an example, one is the original document, and the other is the revised document. Open either of thes....

Creating forms is an essential skill for our daily work. Mastering the form skills can make our work more effective. Now starting from the basic interface, we will explain what a form worksheet and workbook is.First, we click Spreadsheets on the New page, then click Blank to create a new blank file at the bottom. Now enter the main interface of the table. Above the table is the functional area, which is often used when we edit the table. We will also introduce the usage of these featur....

You have learned two types of charts in today's lesson: pie charts and sparkline charts.1.Pie charts are suitable for showing data proportions, and data labels play an important part. The right-hand menu allows us to format data labels. 2.The combo of pie charts and doughnut charts can display complex data. A chart with too many colors should be avoided. We can choose the tone on tone color and adjust the saturation to improve the color matching. 3.Sparkline is a handy chart type. ....

We learned how to share and edit files with our co-workers.There are two methods to share files. One is the traditional method that can be set in the Review tab and shared the file through the local area network. Thus, multiple people can work on the file at the same time. You can trace the revision in the records. Another method is to co-edit online. All you have to do is share the link. The receivers do not need to download WPS Office to participate in the cooperation. The editing re....

What can we do if we want to set the header and footer in odd and even pages respectively? Take this article as an example. Double-click the header of the home page, and click the Header and Footer Options in the Header/Footer tab, then you will see a pop-up dialog box. l Page different settings 1.Check Different first page in the Page different settings to set the header and footer of the first page separately. 2.Check Different odd and even pages to set the header and footer of odd....

When we use WPS Spreadsheet to enter data, we often need to convert between the general and the special format. So let's take a look at what is the general format of cells, what is the difference between them, and how we can convert them. Take this table as an example. The cell contents in the first row of this table are all in the General format. The General format means that the contents of the cells are simply expressed in numerical form. The second row of the table is in a spec....