Excel Add Drop Down Menus

Now for the final type of drop-down list in Excel ActiveX drop-down list. Click Developer gt Insert gt Combo Box ActiveX Control Just like the form control option shown above, draw the drop-down box on the worksheet. Right-click on the drop-down and select properties from the menu. The properties dialog box opens.

It beats typing in the same options 200 different times manually.

Note If you want to create drop down lists in multiple cells at one go, select all the cells where you want to create it and then follow the above steps. 3 Using Excel Formulas. Apart from selecting from cells and entering data manually, you can also use a formula in the source field to create an Excel drop down list.

Drop-down menus, and data validation in general, make it harder to input something wrong in your spreadsheet. But the 'Input message' addition makes data entry even easier - and more bulletproof. When creating a drop-down list, you can add an input message from the 'Input message tab' in the data validation dialog box.

Drop-down lists in Excel are helpful if you want to be sure that users select an item from a list, instead of typing their own values. Create a Drop-down List. To add an item to a drop-down list, go to the items and select an item. 2. Right click, and then click Insert. 3. Select quotShift cells downquot and click OK.

Now, you can select the cell range with your cursor. Click and drag your cursor to select the cell range for the drop-down. With the cells selected, click the quotDownquot arrow towards the right side of the textbox. This will add the cell range to the quotSource.quot Click the quotOKquot button to save the changes. This will create a data validation list in Excel that you can change anytime.

After you create your drop-down list, make sure it works the way you want. For example, you might want to check to see if Change the column width and row height to show all your entries.. If the list of entries for your drop-down list is on another worksheet and you want to prevent users from seeing it or making changes, consider hiding and protecting that worksheet.

Case 1.2 Add Item at the Bottom of Range. Steps Add a new item at the bottom of the Fruit List column. Go to the Data Validation field by following the steps shown before. Modify the Source by selecting the range from the dataset. Mark the option Apply these changes to all other cells with the same settings and press OK. Move to Cell E4 and click on the down arrow to check the drop-down list.

Enter the list of drop-down values in a column. Make sure to enter each drop-down item in a separate, consecutive cell in the same column. For example, if you want your drop-down list to include quotNew York,quot quotBoston,quot and quotLos Angeles,quot you can type quotNew Yorkquot in cell A1, quotBostonquot in cell A2, and quotLos Angelesquot in cell A3.

This tells Excel that you want to create a list of items for the drop-down menu. Step 4 Enter the Items for Your List After selecting 'List', a new field labeled 'Source' will appear.