Creating a simple drop-down menu in Microsoft Excel can seem like a frightening and difficult process, which is best for professionals, but the simple fact is that anyone – even a high school student – Can do this in a few quick steps.
This is the beauty of spreadsheet applications like Excel; They make complex tasks very easy, making them accessible to every user, whether you use them every day in the office or never use Excel in your life.
Here is the simplest way to create a drop-down menu for both MacOS and Windows 10 users.
How to create a drop-down list in excel
Regardless of your Excel skill level, creating a drop-down menu is as easy as a pie (though, unfortunately, not tasty). There is a more technical process, but we are not going to discuss it here; We only cover easy methods, which are two methods: first, by creating a drop-down list using data in cells, and second, by manually creating a drop-down list by items.
Using existing data
In this first method of creating a drop-down list in Excel, we work on the assumption that you have a task list of items in the drop-down list that you want to use, which are already in your spreadsheet Is recorded in
Step 1. Select the cell for the drop-down list.
Make sure this is the cell you want to use in the drop-down menu, so you won’t have to edit later.
Step 2. This opens the data validation dialog box.
Step 3. On the Settings tab, select the menu under Permissions. Ensure that the drop-down list is selected in the cell, if it is not already selected.
Step 4. Click on the Source field. Then click and drag the mouse pointer over all the cells you want to use for your drop-down list.
It selects all of these cells at once and automatically fills in the source field with the data required for your drop-down list.
Step 5. Click OK.
Enter item manually
With Method 2, you do not have a list in your spreadsheet to work with, so you will enter the item manually. To do this, you only have to follow the steps up to step 4.
Step 1. Select the cell for the drop-down list.
Step 2. Go to the data tab and click on data verification to open the data validation dialog box.
Step 3. On the Settings tab, select the menu under Permissions. Be sure to tick the drop-down list in the cell, how to create multiple drop-down lists at once
If you want to create multiple drop-downs at the same time, then you will be happy to know that it is as easy to make. The only difference is that you choose multiple cells – the cells where you want to insert your list.
It has not already been verified.
Step 4. Click on the Source field. Then enter each item in the drop-down menu, separating each item with a comma.
Step 5. Click OK.
Isn’t it painless? It should be noted that there are other, perhaps more difficult, ways to do this. For example, you can use Excel formulas to create a simple drop-down list. You can also create a dynamic drop-down menu that can be easily extended when needed. However, this is a tutorial for another day.
Creating a simple drop-down menu in Microsoft Excel can seem like a frightening and difficult process, which is best for professionals, but the simple fact is that anyone – even a high school student – Can do this in a few quick steps.
This is the beauty of spreadsheet applications like Excel; They make complex tasks very easy, making them accessible to every user, whether you use them every day in the office or never use Excel in your life.
Here is the simplest way to create a drop-down menu for both MacOS and Windows 10 users.
Regardless of your Excel skill level, creating a drop-down menu is as easy as a pie (though, unfortunately, not tasty). There is a more technical process, but we are not going to discuss it here; We only cover easy methods, which are two methods: first, by creating a drop-down list using data in cells, and second, by manually creating a drop-down list by items.
Using existing data
In this first method of creating a drop-down list in Excel, we work on the assumption that you have a task list of items in the drop-down list that you want to use, which are already in your spreadsheet Is recorded in.