0 1

Select the cell to which you want to add the drop-down list, and then click Data on the toolbar.

02

Find Data Validity-Click Data Validity.

03

In the pop-up prompt box, click Set-Set the allowed conditions as a sequence.

04

Check the options of ignoring null value and providing drop-down arrow, enter "Yes, No" (English format is separated by commas) in the source column, or enter "Male and Female" according to personal needs, and click OK.

05

At this point, the cell has been set, select the cell and move the mouse to the lower right corner.

06

When the cursor changes to a plus sign, drag the cell down (that is, fill it quickly).

07

We can see that all the selected cells have drop-down lists.