In this video, I’ll share the quickest and easiest way to create a drop down list in Google Sheets. In this quick video, you’ll also see how to color code your drop down menu. 


00:10 Make the most out of your drop down list 

00:38 How to create a drop down list 

02:56 How to color code a drop down list 

I’ll also show how that would look like in a content planner and the capabilities of these drop down list are endless. You can definitely impress your clients with them, organize your team in a more efficient way and just have fun with it. In case you liked the content planner in the video, you can get it here.  

Quick instructions on how to create a drop down:

Also, if you have any questions whatsoever, feel free to reach out 😉

How to Create a Drop Down (Quick Instructions):

  1. Click on the cell where you want your drop down list to be places,
  2. Right click on that cell. 
  3. Go to “View more cell actions”,
  4. Choose “Data validation”,
  5. Select “List from a range”, 
  6. Click on the window shape icon on the right and select the cells that you want inside of the drop list. 
  7. DONE!

About Vaida

Hi, I'm Vaida, I'm a marketing specialist who focuses on conversions and not just likes and followers. Engagement is great. Followers are great. Hey, even likes are great. But what do all of these metrics mean at the end of the day if you don't get any new sales? I'm always looking for new ways on how to reach your customers and get the best possible ROI. And no, I don't just "boost" a post. When I set up my Facebook campaigns, the visual, copy, and audience goes through extensive testing. My areas of focus: - Digital marketing strategy, - PPC (Google Ads, Facebook & Instagram Ads), - Copywriting, - Lead magnets, - Newsletter campaigns. I don't say I can't, just I'll learn 👏

Leave a Reply

Your email address will not be published. Required fields are marked *