How to add drop down in excel online

July 25, 2022

A free Office suite fully compatible with Microsoft Office

Free Download

It might be the perfect opportunity to learn how to add drop down in Excel with some basic steps. A dropdown list in Excel is a great option when you need to make multiple notes on your work. In this way, you will be able to get the data to your employer in order through software that is a priority for the company.

However, to learn how to add drop down in excel mac, it is only fair that you follow a few steps. It is good that you let yourself be guided in how to add dropdowns in excel and try to get the most out of the information displayed.

How to add a dropdown list in Excel?

If you want to know how to add drop down in excel easily, all you have to do is:

1. Open a new document in Excel.

2. Choose the cell where you want to place the dropdown menu.

3. Now go to the main menu of the software and click on the data tab that would be between formulas and reviews.

4. Within the data tool group, the data validation option will appear, which you must click on.

5. Within the settings, you must look for the list option and click on it.

6. Finally, you will have to highlight the cells you want to add within the options and click OK. If the function is not enabled, you will only have to click on the box and highlight it again.

How to create a dropdown list in Excel using Mac?

In case you are looking for another way to know how to add drop down in excel 2016 or in another version in which you have the software, you have to do the following:

1. To understand how to add drop down in excel 2019 from your mac computer again, you will have to open a blank sheet of the software.

2. You will have to locate yourself in a second Excel sheet and write all the elements that you want to appear in the list.

3. Eventually, you will have to select cell B1.

4. Go to the Data tab and click on validation data inside the data tool group.

5. In the dropdown box, you only have to click on list and configure the source box. A clear example is placing a range of A1:A3 using sheet 2 in Excel.

6. Finally, click on accept.

How to add items to your dropdown list in Excel?

Now that you know how to add drop down in excel online, you may be interested in learning about adding items. This way, you will be certain that the dropdown list can be edited as many times as you want. all you have to do is the following:

1. If you want to add a new item to the dropdown list, you must select an already written item.

2. You will only have to right-click on your mouse and click on insert.

3. Click on move cells down and accept the changes.

All the information you get on adding dropdowns in Excel will be useful to apply in your work or studies. You only have to apply the previously explained methods and hope for the best results in your document.

If you feel comfortable after learning how to add dropdowns in Excel and want similar information, don't forget to go to WPS Academy. You will find guides for correctly using Excel, Word, and PowerPoint on the website. On the other hand, you will have the opportunity to download WPS Office for free.