WPS table How to quickly enter gender

a quick way to enter the gender in a WPS table one: Use the validity of the data

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.

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

How to quickly enter a gender in a WPS table two: Use the 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.

How to quickly enter a gender in a WPS table three: Using auxiliary columns and function formulas

1, the C column as a table auxiliary column, still use "1" to represent "male". When you enter the formula in cell B2 =if (c2=1, Male, female) (Figure 5), you double-click the fill handle in the lower-right corner of the cell to use the quick Input method to complete the remainder of the formula.

2, at this time b column is shown as "female", it does not matter, encounter men, in the C column input 1, the corresponding cell will display "male" (Figure 6).