4 ways to make a drop-down menu in Excel

4 ways to make a drop-down menu in Excel

There are actually 3 other kinds:

1. Create a list

Press ALT + DOWN arrow in a column to generate a drop-down menu (create a list). This method is very simple.

2, development tools-insert-combo box (form control)

If your Excel does not have the development tools option, you can select development tools from the file-option-Custom Ribbon. (Excel2007 for Office buttons-Excel Options-general-show "development tools")

3, Development tools-combo box (ActiveX control)

Note: You can edit and delete in "design mode"

Add: In these four methods, creating a sequence and creating a list is suitable for multiple lines of data entry. Then 22 types of single cells that fit in a fixed format select input. The form Drop-down returns a number, which needs to be converted to the selected character using functions such as index, and the ActiveX Drop-down column menu returns the selected value directly.