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.

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

When we use WPS Document at work, we often need to create a table in order to make the document more organized. But how are we going to make it? Take this blank document as an example. Click the upper tab Insert-Table. We can choose the corresponding number of rows and columns according to actual needs.For instance, if I want to make a table with 2 rows and 8 columns, just select 2*8 in the table area and click the left mouse button. You can also click Insert-Table-Insert Table. Then ....

When using WPS Spreadsheet, we often need to locate a cell or a cell range to view data. If the table contains a lot of data, it will be very troublesome to look up the target cell or cell range by dragging the scroll bar with the mouse. Now, we are going to introduce three options to quickly locate cells.· Option 1 Ctrl+Home key can help us quickly locate the first cell of this table.Ctrl+End key can help us quickly locate the last cell of this table. We are locating at cell O56. Pres....

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

In WPS Spreadsheet, we can use the AVERAGE function to quickly find the average value of a set of data quickly. It is often used to calculate average wages, average sales, and so on. Take this table as an example. We now need to find the average sales of the bakery this week. After we click cell D4, click Insert Function, and enter AVERAGE in the Search for Function of the dialog box. Click the OK button, and then the Function Arguments dialog box will pop up. The data we filled in Num....

If we modified the data source after creating a PivotTable, how can we make the contents of the PivotTable change with the data source? Take this table as an example. We select cell F15 in Sheet1, and change Violin's Total sales to 800. Then we go back to Sheet2 only to find no change in the values of the PivotTable. At this time, we click the Option tab and click the Refresh button to refresh the PivotTable. If we are afraid of forgetting to refresh the data, click Options in the ....