Download WPS Office for your device

How to quickly extract data of a certain category from a large amount of data? The filtering feature of WPS Office can help us to do it quickly. Take this table as an example. How are we going to filter out the data of New York? 1. Select any cell in the list.2. Click the Home tab.3. Click the AutoFilter drop-down button or use the shortcut key CTRL+Shift+L to set. Then the data list will enter the filtering state. 4. Click the gray inverted triangle arrow in the header cell of Branch,....

The filter function is often used in data processing, but only when the data is vertically arranged. Today we will filter data horizontally using two ways.· 1. Transpose dataTake this table as an example. To filter the sales of all categories, we need to select and copy the entire table with Ctrl+C and then right-click Transpose at Paste Special. By doing so, the table is transformed into a vertically-oriented table. Go to the Home tab, and click AutoFilter to get the sales of all cat....

Cell formatting is an important feature of spreadsheets. So today, we will briefly go through how to format cell values. Number formatting can be simply understood as a digital form that can be used for calculations.Take this table as an example: now the data in the cell is in text formatting. If using the SUM function to do calculations, we would find that the data in text format cannot be calculated. At this time, we need to convert the data into a number formatting that can support ....

Sometimes we don't want to enter duplicate information from the collected data. We will take the unique telephone number as an example to show how to use the Validation function to prevent duplicate values.Select this column, and click Validation at Data, you can also use the shortcut Alt+D+L. Head to the Setting tab, click the Allow drop-down button and select Custom, and enter countif(D:D,D1)=1.This formula will make the value in cell D1 only appears once in column D; otherwise, ....

No matter you are a student, teacher, or business professionals, you can create and edit documents efficiently by WPS Writer as text editors. Student Tools is a collection of functions launched by WPS for students users. Some frequently-used functions are selected. This built-in function cannot be found in other office software at present. In the interface of this function, WPS Office selects Reading View mode from the View tab, frequently used features such as Highlight and Text Color....

In the workplace, collecting all kinds of documents is frequently needed. At this time, a file folder is always wanted to collect what we need by sending a sharing link to others.At present, such a function is not available in other office software on the market. Fortunately, WPS launched the File Collect feature for a more efficient office experience. Here's how to use this feature. · Step 1: Create a shared folderHead to the Tools tab and click File Collect. In this interface, th....

Presentation Tools is a feature for WPS Office that can quickly modify the font and size of slide texts, and insert pictures to multiple slides in batches. We can see four options here: Replace Fonts, Batch Font Settings, Customize Text Formats and Insert Picture to Multiple Slides. Microsoft PowerPoint has similar functions as well, such as Replace Font, New Photo Album and Edit Master Slide. However, their entry points are scattered which means the users may need to switch back and f....

Lookup and Reference functions are frequently used for processing data in a table. Today we will learn how to use the FILTER Function to filter data.This function can be used to filter a range of data based on the criteria that you specify.· Primary usage of the Filter functionTake this table as an example. Suppose we want to get the list of class 1, Select G3:G15, this is the cell range we want the result to return, so don't just select cell G3.Enter the formula: =FILTER in the ce....