 Select the column or cells where you want to apply the drop-down menu, then go to the Data tab. In this section, go and click on Data Validation. A small window is opened. Here in the Allow section, select the List option. View my caffeine addiction with a cup of Joe, please. In the Data section, leave as is. And finally in the Source section, write the options you want to use separated by a comma. Then click OK and that's it. As you can see now, with just one click the drop-down menu is ready with the options you just set up. If you enjoyed this content, please like this video.