Create Drop Down
In this article, we will learn how to create a drop-down list with colours in Microsoft Excel.
The drop-down menu restricts the user to select a value from the provided list instead of adding the values to the sheet.
Complete Drop Down training video
We will use conditional formatting and data validation options. First, let’s understand how to create a drop-down list in Excel with an example here
The Data Validation dialogue box appears as shown above.
Now click Home > Conditional formatting. Select New rule from the list and a dialog box will appear.
Select the Specific Text option and select the cell for colour as in this case Red.
Select Format > Fill option. Select the Red colour and click OK.
Repeat the process for all the options like Green and Blue and your list will be shown below snapshot.
How to Delete Drop Down List in Microsoft Excel
To delete or remove an already existing dropdown list. Just follow the simple steps as shown below.
Using the Data validation option we can remove the dropdown list
Select the cell where you wish to remove the dropdown list.
You May Like