Excel quickly makes a drop-down menu, taking making a first-level drop-down option as an example, and sharing three methods, the specific operation steps are as follows.

Method 1: List the menu.

First, write the menu names in the blank cells of the table by column, then select the cell area where the menu needs to be set, and then click Data-Data Verification-Data Verification in turn on the toolbar;

Enter the setting interface, select the sequence where it is allowed, select the listed menu area at the source, and confirm. As shown in the figure below:

Method 2: direct input

Without listing menu names, select the area to be set, and directly click Data-Data-Data Verification-Data Verification on the toolbar;

Enter the setting interface, where the sequence is allowed to be selected, enter the menu name at the source, separate it with commas in English, and confirm. As shown in the figure below:

Method 3: Define the name

List the menu name and define the name of the column area where the menu name is located. First, click the menu area, and then click Formula-Name Manager-New to enter the setting interface;

Set the name, any name, convenient and easy to remember. Click OK to return to the previous interface, and click Close.

Then click Data-Data-Data Verification-Data Verification in turn on the toolbar; Enter the setting interface, where the sequence is allowed to be selected, and enter: = the defined name at the source. For example, if the defined name is department, write = department and confirm. As shown in the figure below: