Web open the excel document, and you should automatically choose the data you want from the dropdown list.
How to create drop down list in excel with color. So , let’s enter the values in the range a1 to a3 as shown. Inserting drop down list 3. Simply click the arrow and select an option.
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. You can add or delete items from your drop. Web it’s easy and we’ll show you how.
Go to the data tab that would be located between.