1. Open the EXCEL table to be operated, select the cell to set data validity, find it in the data toolbar, and click Data Validity.
2. Select the sequence in the options menu below, then enter the text content to be used as data in the source input box, separate the options with English commas, and click the OK button below.
3. Return to the EXCEL table and find that the data validity has been set successfully. You can select content input in the drop-down menu.