Question

Excel: create a dropdown menu - this is how it works

Answer 1

How to make a drop down list in Excel
1st step:
2nd step:
3rd step:
4th step:
Video
Quick start: Create a drop-down list in Excel

---

Would you like to create a drop-down menu in Excel for easy entry? We'll show you how..

The Excel spreadsheet program from Microsoft can seem a bit complicated at times. But with functions such as a drop-down list, clarity can be created. Follow our guide to find out how you can make such a selection in just a few steps.

How to make a drop down list in Excel

Follow our step-by-step instructions , the quick start guide or the explanatory video .

By the way: You can design the cells around the drop-down menu as you like. For example, you can put a heading in the cell above..

1st step:

Select all cells into which you are about to insert the drop-down list. This can also be a single cell. Then select the menu bar tab " Data " and the option " Data verification ... ".

2nd step:

It will open in a new window. Under " Allow: " you will find a drop-down menu that is automatically set to " Any value ". Change this option to List .

3rd step:

Then under " Source: " enter the values ​​that should later be available for selection in the drop-down menu. You have to separate them with a semicolon in order for them to be recognized as different elements. Alternatively, enter a cell range or click on the selection button (arrow up symbol) and select a cell range accordingly. Confirm your entry with " OK ".

4th step:

If you now click on one of the selected cells, a small arrow appears to the right of it . Clicking on it will display all of the options you just entered. Clicking on one of these options will automatically insert the element into the cell .

Video

Quick start: Create a drop-down list in Excel

1. Select the cells in the table in which you want to include the drop-down menu. Then click on " Data verification ... " in the " Data " tab .
2. In the new window, click the arrow in the drop-down menu under " Allow: " next to " Any Value ". Then select the " List " option .
3. In the line under " Source: " you must add your options for the drop-down list, separated by a semicolon. Otherwise you can also specify the cell range directly.
4. Confirm with " OK ". If you now click on one of the fields provided with a drop-down selection, an arrow will appear to the right of it. Clicking on it shows you the choices you have entered.

---