- In your Excel workbook, select the cells that you want to apply the drop down menu to.
- Click on the Data Validation menu (in the Data tab in the Excel Ribbon), or use the shortcut Alt-A-V-V.
- In the “Allow:” dropdown menu, select “List”.
- In the “Source:” box, enter in your values separated by commas.
- Click OK to save the Data Validation options. Your cells will now have a menu when they are selected in Excel.
- Select the cells that you want to contain the lists.
- On the ribbon, click DATA > Data Validation.
- In the dialog, set Allow to List.
- Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.
How do I add a drop down menu?
Add menu items to include in the new drop-down menu. Click Add menu item, enter the name of the menu item, and enter or select a destination for the link. Click and drag the menu items to nest below the header item. Click Save menu. Note.
How do you add a drop down box in Excel?
Example #1 – Dates Drop Down List
- First, select the cell where we need to create a drop-down list.
- Now click on Data Validation under the “DATA” tab.
- This will bring below the data validation window.
- This will bring below the data validation window. ...
How do you create a drop down?
- Almost three out of every four Americans now have immunity to the Omicron COVID-19 variant, an analysis finds
- Covid cases in the U.S. ...
- Vermont and Virginia have both joined the growing list of states that have or plan to relax mask mandates in recent weeks
How to create a dropup menu?
Create a drop-down list using existing data
- In the spreadsheet, select the cell where you'd like to create a drop-down list.
- In the Excel Ribbon, click the Data tab.
- On the Data tab, click the Data Validation option.
- In the Data Validation window, click the Allow drop-down list and select the List option.
How do I create a custom drop-down list?
Edit a drop-down list with items that have been entered manuallyOn the worksheet where you applied the drop-down list, select a cell that has the drop-down list.Go to Data > Data Validation.On the Settings tab, click in the Source box, and then change your list items as needed.More items...
How do I create a drop down menu in a column?
1:133:22How to Create a Drop-Down List in Excel - YouTubeYouTubeStart of suggested clipEnd of suggested clipAnd create our first drop-down list click into the cell in which you want to create the drop-downMoreAnd create our first drop-down list click into the cell in which you want to create the drop-down menu. Then click on the tab data go to data tools and select the option data validation.
How do I create a drop down list in Excel and show different values?
How to create drop down list but show different values in Excel?Create drop down list but show different value in drop down list cell.Create a range name for the cell values you want to use in the drop down list, in this example, I will enter the name dropdown in the Name Box, and then press Enter key, see screenshot:More items...
How do I create a drop down list in Excel with multiple selections?
To create the drop-down list:Select the cell or cells you want the drop-down list to appear in.Click on the Data tab on Excel's ribbon.Click on the Data Validation button in the Data Tools group.In the Data Validation dialog, in the Allow: list select List.Click in the Source: box.More items...
Community Q&A
How can I add a drop down list, but not show all of the items in each row?
Tips
After you finish creating your drop-down list, open the drop-down list to make sure all the items you entered display properly. In some cases, you may need to widen the cell in order to display all your items fully.
Warnings
You will not be able to access the "Data Validation" menu if your worksheet is protected or shared. In this case, make sure to remove the protection or unshare the document, and then try to access the Data Validation menu again.
About This Article
This article was co-authored by wikiHow Staff. Our trained team of editors and researchers validate articles for accuracy and comprehensiveness. wikiHow's Content Management Team carefully monitors the work from our editorial staff to ensure that each article is backed by trusted research and meets our high quality standards.
How to Create a Drop-Down List in Excel?
Click on the data menu and choose the data validation menu as shown below.
Recommended Articles
This has been a guide to Drop Down List in Excel. Here we discuss creating a Drop Down List in Excel and practical examples and a downloadable excel template. You can also go through our other suggested articles –
Create a drop-down list using existing data
If you want to create and insert a drop-down list using data already entered in the spreadsheet, follow the steps below.
Create a drop-down list by defining the list of values
If you want to create and insert a drop-down list, and define the list of values to display, follow the steps below.
