WPS table How to quickly enter gender

WPS Table A quick way to enter a gender

Using data validation settings to implement fast input

1. When you select the cell range that holds the gender, click Validity under the Data menu, pop up the Data Validation dialog box, click the Drop-down arrow to the right of the Allow option, click Sequence in the Drop-down list (Figure 1), and type "male, female" in the text box below the source option ( Note: When the comma needs to be entered in English state (Figure 2), click OK to close the dialog box. WPS Tutorial

2. Select the corresponding cell, click the Drop-down arrow that appears to the right of the cell, and click the Gender in the Drop-down list that pops up (Figure 3).

WPS table quickly enter the method of sex two

Implement fast input with substitution function

1, in the Gender column input "1" for "Male", "2" for "female".

2, select the related cells, click the Edit menu under the Replace command, in the pop-up "Replace" dialog box, enter the corresponding find content and replace content (such as Figure 4), click the Replace All button.