How To Make A Drop Down List and Highlight Duplicates On Spreadsheets

  • WPS Office, Productivity

When you are working with large data sets, making drop down menus can qualify the data entered, which will greatly decrease the error rate of input data. Furthermore, if you want to know what is repeated in a set of data, counting one by one is troublesome, the highlight duplicates function may help you. To use these two functions, follow the steps as below:

Make drop down menus
Step 1. Select the data area you want to fill in.
wps office installation in different language

Step 2. Choose the “Data” tab of the top menu, click Validation, and you will see the Data Validation dialogue box.
installation path

Step 3. Choose the “List” for Allow, and in the Source box, you could enter “One,Two,Three,Four,Five,Six” or you can enter what you want to use in some other cells, and use the mouse to select this data area.
installation path

installation path

Step 4. Press the “OK” button to complete, and you will see the button on the right of every table cell. Click it to choose any of them to fill in the cell.
installation path

Highlight duplicates
Step 1. Select the worksheet range that you want to highlight duplicates.
wps office installation in different language

Step 2. Click the Home tab, click “Conditional Formatting”, and choose”Highlight Cells rules”, then click “Duplicate values”.
installation path

Step 3. A box will display asking how you want the duplicates to appear.
installation path

Step 4. Click OK. The results are as below:
installation path