How Excel makes a drop-down menu

1, open Excel form, here is a Baidu experience related data, there are experience, votes, comments, fans and red envelopes number, here mainly to the number of red envelopes as today's tutorial settings.

2, in the need for the Drop-down box menu selection of the table, select All.

3, in the Excel main menu, select the "Data" function menu, find the "Data validation" tool, in the Pop-up function menu select "Data validation."

4, in the Data Validation Settings page, select the "sequence" in the allowable condition, and then click on the icon on the right of the source to select the appropriate number range.

Click OK, put the mouse in the red envelope in the space, there will be a Drop-down box icon, click the Drop-down icon according to the number of experience to select the corresponding red envelope number.