How to Create Drop Down Menu in Excel

Solution

1.     Open Microsoft Excel.

2.     Enter numbers in A1:A10 as the list source. These numbers will appear in the drop-down list. Select the cell (here is E5) that will contain the drop-down list. Choose Date-> Date tools-> Date Validation to access the Data Validation dialog box.

Enter source and access the dialog box.

Data Validation dialog box

3.     In the Settings tab, select the List option in Allow drop-downlist. Make sure that the In-Cell Dropdown check box is checked.

Select the list option.

4.     Then, click here . The following dialog box will appear.

date validation box

5.     Select the items that will appear in the dropdown list from the worksheet using your mouse , click and return to theData Validation dialog box, click OK.

6.     Then, a drop-down list is created .

A drop-down list is created.

Tips

• If your list is short, you can enter the items directly into the Source control in the Settings tab of the Data Validation dialog box. And separate each item with list separators specified in your regional settings.
• If your list is in a range on a different worksheet, you can provide a name for the range and then use the name as your list source (preceded by an equal sign). For example, if the list is on a different sheet in a range named List, enter the following: "=List".

exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter exchange spam filter