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

How to put drop down list in excel with color. Web how it works: Hit v alidation from d ata tab. If you don't want users to.

Inserting drop down list 3. You can add or delete items from your drop. Go to the data tab that would be located between.

Make sure the “show input message when the cell is selected” box is checked. Open the excel document, and you should automatically choose the data you want from the dropdown list. 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.

Create source data in h126:h128.