How to add drop down in excel cell

July 22, 2022
759 Views
0

A free Office suite fully compatible with Microsoft Office

Free Download

You may urgently need to learn how to add drop down in excel, but you have received the wrong information about it. It is time for you to know the safest way to know how to add drop down in excel Mac and even on your Windows computer. With a drop-down list in Excel, you can organize the data of the company you work for and even your finances.

The process of knowing how to add drop down in excel is simple, and you will be able to have the element in a matter of seconds. The only thing you have to worry about is focusing on following the steps of each method that will be shown below.

How to add a dynamic dropdown menu in Excel?

To know how to add drop down in excel 2016, but with a dynamic origin, you must do the following:

1. You will need to open the Excel document and select a cell which in this case would be B1.

2. Now go to the data tab and locate the data validation option that will be inside the data tools group.

3. Within the data validation box, you will have to select list within the allow option. Then you will have to click on source and enter the following formula: =OFFSET(Sheet2!$A$1,0,0, COUNTA(Sheet2!$A:$A),1). Finally, click ok.

4. Now open the second sheet in Excel, select the same cell B2 and click on the desired dropdown option.

How to add a dependent drop down list in Excel?

Now that you understand how to add drop down in excel Online, you may find it easy to know how to drop this dependent tool. To complete the process, you must do the following:

1. Create the dropdown list in Excel through the previously explained formula. That is, =OFFSET(Sheet2!$A$1,0,0,COUNTA(Sheet2!$A:$A),1). But this time, you will need to create a second list, as shown in cell E1.

2. Each drop down list will have its selection for you to use correctly at work. This example was used as a reference to what you would find in a pizzeria.

How to add other entries in the dropdown list in Excel?

You might also be interested in learning how to add drop down in excel 2019, but with other posts. To fulfill this purpose, you must do the following:

1. You must select any cell in the Excel file, go to the data tab, and then data validation.

2. Within the data validation box, you will have to click on error alert and uncheck the option show error alert after entering invalid data.

3. Save the changes, click on the dropdown list and add the data you want.

Conveniently, you know how to add drop down in excel to apply it to your work documents. In this way, you will give your employer a personalized file that will undoubtedly be useful to the company. You have to excel at using these tools and try to learn each step.

If you liked all the information about how to add drop down in Excel but have many doubts about it, you can download WPS Office without spending a penny on office software.