Make sure the “show input message when the cell is selected” box is checked.

How to put drop down list in excel with color. Go to the data tab that would be located between. So , let’s enter the values in the range a1 to a3 as shown. Web how it works:

Web introduction create drop down list in excel with color (data validation) presentation process 418k subscribers subscribe 3k 274k views 3 years ago work with. Select one or more cells where we want the dropdown list to appear. Create source data in h126:h128.

Inserting drop down list 3. Open the excel document, and you should automatically choose the data you want from the dropdown list. You can add or delete items from your drop.

Web to do this, click the “input message” tab on the data validation dialog box.