Make an Excel pull-down menu

Excel is really too much, in the production table, if the serial number is too many, has been ranked below, today to teach you how to make Drop-down menu, shorten the format.

Step one: Open excel2010 to select the following legend for data validation below the data item:

The second step: in the "Allow" box to select "Sequence" in the source selection of the Production Drop-down menu content, such as the following figure is selected in the "Sheet2 table A1 to A3", and finally click "OK" to complete the Drop-down menu production.

After the production, click on the production of a good cell, there will be a pull menu Drop-down arrows, the following legend:

When we click the dropdown arrow, we will have the content of the "source" selected when we make it, the following legend:

The following legend is I want to show you, drop-down menu a small function "Select a level, B1 cell will appear 1000 yuan, select two levels, B1 cell will become 800 yuan, in order to achieve this function, the premise of our B1 cell entry."

The arrow in the figure below refers to the formula in the B1 cell.