Creating Drop-Down Menus in Google Sheets

Did you know you can create a drop down menu in Google Sheets? This is a handy feature if you are wanting students to choose from a list of questions to answer. The cell directly under your dropdown menu can be used for the students to type their answers.

  1. Click on the cell where the questions will be added.
  2. In the main menu, click on Data and then Validation
  3. Next to criteria, choose list of items. Type your questions in the box, separated by commas. 
  4. Check the box next to show dropdown list in cell and add directions in the description box if desired.
  5. Click on save.

I created a couple of examples demonstrating how to use this feature. Hopefully this will inspire some ideas to help get you started.

Leave a Reply

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