You can add or delete items from your drop.
How to create drop down list in excel with color. Here is a quick discussion of. Select one or more cells where we want the dropdown list to appear. Web presentation process 418k subscribers subscribe 3k 274k views 3 years ago work with ms excel like a pro learn how to create drop down list in excel.
So , let’s enter the values in the range a1 to a3 as shown. Go to the data tab that would be located between. Step 2 now click the new.
Web open the excel document, and you should automatically choose the data you want from the dropdown list.