Clear and Avoid Duplicates Entries in WPS Spreadsheet
When using WPS Spreadsheet to process a large number of data, it would be troublesome to find duplicated items manually. Here are some two options to delete duplicates. · Option 1: 1. Select a range of cells. 2. Get into the Data tab → click the Highlight Duplicates dropdown button3. Pick the Set option from the drop-down list. Then, duplicated cells within the selected range will be highlighted.4. Right-click to select the fifth row → choose Delete in the popup menu· Option 2: 1. Se....
How to insert and change the name of the slicers
Slicer is a very useful feature in WPS Spreadsheet. It can only be applied to a Pivot Table and can help users quickly filter various data. To learn more about the pivot table, you can watch some related videos in our WPS Academy.First, we need to create a Pivot Table.1. Open the table in WPS Spreadsheet, click the Insert tab → and click the PivotTable button, then the Create PivotTable interface will pop up.2. Select the cell range of the Pivot Table in the Select a range area.3. Sele....
How to refresh the pivot table in WPS Spreadsheet
1. Use WPS Office to open the spreadsheet.2. Click the Data tab → and then click the Refresh All button. This skill could also be used in Microsoft Office Excel and OpenOffice.
How to create a dropdown list in WPS Spreadsheets
When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word. An example of cells with a dropdown list is shown below. How can we realize it? An example of cells with a dropdown list inserted · Option 1: 1. Select the cell range to insert d....
How to cancel filter in WPS Spreadsheet
1. First, use WPS Office to open the table. 2. Click the small icon at the lower right corner of the manipulated cell.3. Place the mouse cursor at the Select All label. Then a green Clear Filter button will appear.4. Click the Clear Filter button. Now we have successfully cancelled the filter.To be an office excel advancers, you could learn how to use WPS Office Spreadsheet online in WPS Academy.
How to create a dropdown list in a worksheet
When using WPS Spreadsheets to process a spreadsheet with a large number of data to fill in, creating a dropdown list in the target cells is able to boost our working efficiency, since we can choose one of the options from the dropdown list to fill the target cells rather than typing the contents word by word. An example of cells with a dropdown list is shown below. How can we realize it? An example of cells with a dropdown list inserted · Option 1: 1. Select the cell range to insert d....
How to sort a pivot table
1. Open a Spreadsheet with Pivot Table.2. Place the cursor on the heading cell of the data we want to sort.3. Then click the small drop-down button on the bottom right corner of the cell.4. In the drop-down menu, we can select Ascending or Descending according to our needs. This skill could also be used in Microsoft Office Excel and OpenOffice.
How to sort data in a worksheet
1. Select the cell range filled with data to be sorted.2. Click Data → Sort → choose a sorting method (Ascending or Descending) When choosing Descending, the data would be sorted from the maximum to the minimum values (or Z to A for text). When choosing Ascending, the from the minimum to the maximum values (or A to Z for text). Note:When you see the Sort Warning pop-up dialog, you can choose one of the two options for array to be sorted.lIf you choose 'Continue with the current ....