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. Today, we will learn how to create a Form in WPS spreadsheet, which allows us to input, search and modify the data. Note: If the table contains merged cells, the Form function will be unavailable. · 1. Data inputFirst, click the Data tab and click the Form button. In the pop-up window, the system will automatically take the title row as the field name. ....

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

In daily work, we often need to summarize and calculate some related data. By using the Consolidate feature, we can quickly calculate the data in multiple worksheets. This feature can be also used in Microsoft Office Excel and Openoffice. Now let's learn it together! Take the following table as an example. You can see that there are sales data from different staff. Now we want to count the total sales volume of all employees. 1. Create a summary sheet in Spreadsheet.2. Select cell....

In our daily work, we may encounter some table data with a vertical layout. Using the proper layout style for different tables will make it more convenient for us to check data. So how can we change horizontal data to vertical?1. First, we use the shortcut key Ctrl+A to select all the contents in the table.2. Then use Ctrl+C to copy the selected cell range. 3. Right-click and select the Paste Special option.4. Select Transpose in the popup menu. Then the horizontal data will immediatel....

In this lesson, we have learned several ways to set conditional formatting. 1."Highlight Cells Rules" and "Top/Bottom Rules." They can highlight cells quickly and draw people's attention to data that matches the conditions. 2.Data bar, Color Scales and Icon Sets can visualize data and make them clearer to recognize. 3.We also learn how to add multiple formatting to data using the AND function.In the selected area, we can set multiple conditions, delete specific rules or clear all ....

1.This lesson explained the primary usage of PivotTable.Four PivotTable areas are crucial, ROWS and COLS areas primarily influence the table's structure.VALUES is for analysis and FILTERS is for filtering. Different reports can be generated by combining different fields.2. The application scenarios of pivot tables are explained through 3 cases:You can group the dates in a PivotTable;You can also insert calculated fields into a PivotTable.It's easier to analyze if the numerical ....

1.In this lesson shared several chart types, such as column, line, pie, bar, area, scatter, radar, and bubble chart. Each chart has its own features and imperfections. We should pick the chart that best fits the topic. 2.Many different elements make up a chart, such as a chart title, data labels, trendlines, and so on. We should pick elements appropriately, concisely, and clearly. 3.We also learn the basics of ribbon buttons. We know how to change the chart type, how to switch rows and....

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