excel2013 a tutorial on making a Drop-down menu

EXCEL2013 Open the worksheet that you want to edit, example is a class list and you can see the political landscape is not yet filled out

Then we find a blank place, in turn, the possible options for the political landscape: the masses, the league members, the CPC, the Democratic parties

Then select the "Political Face" column, click "Data" in the menu bar, then select "Data Validation" and select "Data Validation" from the Drop-down menu.

In the pop-up window, select the validation criteria, select "Sequence" in the Drop-down menu, select the position of the masses, league members, communists and democratic parties in the following sources, then click "OK"

This will be in the "political face" column of the cell next to a drop-down cut head, click on the corresponding selection will appear.

6 If you want to clear the format setting, you can select the "Political Face" column, click "Data" in the menu bar, then select "Data Validation", select "Data Validation" in the Drop-down menu, and select All clear in the pop-up window to clear the Pull-down menu.

excel2013 to make a drop-down menu (ii)

After opening the Excel2013, select the data option, open the Data Validation drop-down menu, and select data validation

In the data validation menu that pops up, select series

Fill in the data you want to fill in the source, separate each data by a comma in the English input state, and determine

Take a look at the effect of the Excel2013 pull-down menu