How to add content to excel drop-down box

Adding method: First open the excel table that needs to be operated, click "Data" - "Data Verification" at the top of the page; then in the pop-up "Data Verification" window, select "Sequence" from the "Allow" drop-down list ”, enter the specified value in the “Source” input box; finally click the “OK” button.

The operating environment of this tutorial: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

Open the excel2010 table, and there are two young and old people in the drop-down menu.

Click the Data-Data Validation Options button.

Call up the data verification dialog box.

Click on data verification, select the sequence, the comma is in English

Add old age in the box, Click the OK button.

Related learning recommendations: excel tutorial

The above is the detailed content of How to add content to excel drop-down box. For more information, please follow other related articles on the PHP Chinese website!