WPS Office

Free All-in-One Office Suite with PDF Editor

correct-icon

Edit Word, Excel, and PPT for FREE.

correct-icon

Read, edit, and convert PDFs with the powerful PDF toolkit.

correct-icon

Microsoft-like interface, easy to use.

Free download

Windows • MacOS • Linux • iOS • Android

banner

How to add a dropdown list with color in excel

February 13, 2023
5.3K Views

If you want to specialize in-office programs, learning to use some tools would be only fair. It is time to learn how to add a dropdown in excel 2019 using very simple techniques that you will find online. This process of how to add a dropdown in excel could be divided into three methods that will serve you very well.

It is good that you learn how to add a dropdown in excel, knowing that the program takes priority in the office. In this way, you will be prepared to excel at work and give your best.

How to create a dropdown menu in Excel?

If you are looking for the first method to know how to add a dropdown in excel Mac or on your Windows computer, you should do the following:

1. Open the Excel document, and you should automatically choose the data you want from the dropdown list.

2. Go to the data tab that would be located between formulas and review.

3. Now click on data validation.

4. In the data validation box, you will have to look for the list option.

5. Select the list in the source and finally click on accept.

How to edit the dropdown menu in Excel, considering the range of cells?

It may have made sense to you to know how to add a dropdown in excel Online, and you are interested in learning how to edit the element. For this case of how to add a dropdown in excel, you will take into account the range of cells and proceed to do the following:

1. Enter the Excel sheet where you have the data in the drop-down list.

2. Select the cell you want to edit, go to the data tab, and click on data validation.

3. Within the data validation box, you will have to adjust the range of cells to include them in the document. Finally, click on accept.

How to edit the dropdown menu in Excel, considering the range of names?

You could also learn how to add a dropdown in excel 2016, considering the range of names. However, to execute this method, you will have to follow the following steps:

1. You will have to open your Excel document again with the previously created drop-down list.

2. Go to the formulas tab and click name manager.

3. You must select the named range your dropdown will focus on and eventually edit the references formula. This way, you could add or exclude some elements in the dropdown list. After making the adjustments, you will only have to click on accept and save the changes.

It may have been easy for you to know how to add a dropdown in Excel so that you will have no excuses to apply it in your future documents. However, you will have to search for more information about it to get the most out of the tool. Excel should be one of the programs you use the most with priority for your company.

After knowing how to add a dropdown in excel, you may be interested in having more similar guides on using tools in the program. To have a pleasant experience knowing how to add a dropdown in Excel or with other tools, it is only right that you go to WPS Office. You will also learn how to use Word, PowerPoint, and other Office programs with the website.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.