Check-Menus.com

how to make a drop down menu excel

by Zetta Balistreri I Published 3 years ago Updated 2 years ago
image

Create a drop-down list
  1. Select the cells that you want to contain the lists.
  2. On the ribbon, click DATA > Data Validation.
  3. In the dialog, set Allow to List.
  4. 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.

Full Answer

How do I create a drop down menu?

Steps:

  • Click the name of your main menu.
  • Choose one of the menu items to be the header for your drop-down menu, or add a new menu item to be the header. ...
  • Add menu items to include in the new drop-down menu. ...
  • Click and drag the menu items to nest below the header item.
  • Click Save menu.

How do you create a drop down table in Excel?

Here’s the quickest way to set up a drop down menu in Excel:

  • 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.

More items...

How to create drop down buttons in Excel?

Now let’s see how to get the Grade to the drop-down list as follows:

  • Go to the Data tab.
  • Select the data validation option.
  • You will get the dialogue box which will show validation criteria.
  • Choose the List option from the drop-down list.
  • Place the cell in the G column as shown below in the screenshot to get the drop-down list menu.
  • Select the database column from C2:C8.
  • Click ok.

How to make responsive drop down menu?

You May Like This:

  • Responsive Footer Section
  • Complete Portfolio Website
  • Responsive Navigation Menu
  • Responsive Side Navigation Bar

image

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.

image
A B C D E F G H I J K L M N O P Q R S T U V W X Y Z 1 2 3 4 5 6 7 8 9