Download WPS Office for your device

When using WPS Spreadsheets to process data reports, grouping data in proper ways can present data more clearly and boost our productivity. The spreadsheet in this example presents a company's sales performance during the first half of a year. To make it more convenient for data viewing, we can group the data belonging to the same category. 1. Select cells of Column B and Column K. 2. Get into the Data tab, and click the Group button. (Tips: You can also press the shortcut keys Shi....

The Worksheet feature of the WPS Spreadsheet can perform several basic operations on the table. So now I'm going to show you the usage of Worksheet feature that it could be also used in Microsoft Office Excel and Openoffice. · Insert SheetClick the Home tab, select Worksheet, then select Insert Sheet. Now we can set the number and position of the insert in the popup dialog box. Or we can also click the plus sign in the bottom column of the table to add directly.· Delete SheetClick....

When using WPS Presentation, we often need to edit text content in the text box. So how can we insert a text box? First, click the Insert tab above and click the Text Box drop-down button. Here, we can choose to insert a Horizontal Text Box or a Vertical Text Box. This video of How to insert and set a text box will only take the horizontal text box as an example, which could be compatible with Microsoft Office powerpoint. Click Horizontal Text Box and then long-press the left mouse but....

1. The basic rules of inputting data.2. Commonly-used fill functions (Fill handle, Series, and Flash Fill).3. Create simple drop-down lists for higher efficiency.4. Use the OCR function for quick input.

The main knowledge points of this lesson are the following 4 points。1. We can use the Freeze Pane, Eye Protection, and Reading Layout functions when processing tables with large data. 2. To view multiple worksheets in the same workbook simultaneously, we can use the New Window and View Side by Side functions or use the Split window function to work with multiple windows without interference. 3. To compare data, we can use the View Side by Side function, but it's easier and more con....

Before we preview or make a presentation with slides, we should set up the slideshow in advance. So, how are we going to set it? Take these slides as an example. We first need to click the Slide Show tab at the top and then click the Set Up Show drop-down button. Here, we can set the slideshow as Manual or Auto.If we want to customize the slideshow settings, click the Set Up Show button. In the popup Set Up Show dialog box, we can also set the show type, multiple monitors, etc... In Sh....

When we edit a document with WPS Writer, if we want to highlight the separation of paragraphs, we can set a Drop Cap effect in the paragraph. In this way, the first letter of the paragraph is a large capital letter and it occupies multiple lines, making the paragraph separation more noticeable. · 1. DroppedTake the first paragraph as an example. Select this paragraph. Click the Insert tab and the Drop Cap button, then a dialog will pop up. In the Position area, we can choose None, Drop....

As we all know, we can protect the sheet by setting a password. So, can we divide this table into several ranges and set up separate passwords for each range? The answer is yes. Take this table as an example. This is a student grade table, and we need to set different passwords for each of the three ranges in the table so that the three ranges do not affect each other. Next, I will show you how to do that.Click the Review tab and the Allow Users to Edit Ranges button, and click New. In....