Web go to the data tab on the ribbon, then data validation.

Add drop down checkbox in excel. Web instead of dropdown box, list box is best suitable to add check boxes for multiple selection. Web how to make excel drop down with multiple selections. Check checkbox to change row color.

First, you make a regular data. Web go to the data tab and click on data validation in the data tools group. On the ribbon, click the data tab, and click data validation.

Web 📌 step 1: If you can’t click data validation , the worksheet might be protected or shared. Select the cells that you want to contain the lists.

Let me explain how to do this in excel (most of excel commands & methods are. In the dialog, set allow to list. Following, click on the insert tool >>.