1. Open Excel and select C4 cell.

2. Click the data menu bar, and then click the data validity drop-down menu.

3. Select the data validity button in the data validity drop-down menu.

4. In the pop-up window, the validity condition allows you to select Series from the drop-down menu, which belongs to Yes or No in Source; You need to pay attention to the comma between yes and no, you need to use the comma in English, otherwise Excel will not recognize it, which will lead to. "Yes, No" also appears in the options. Click the "OK" button.

5. Move the mouse to the lower right corner of C4 cell, drop down after the cross star appears, and finally complete the production of other table data.