How To Create Drop Down Selection List In Google Doc Spread Sheet

Google Docs spreadsheet makes it easier to get the required inputs from students / employees but to maintain consistency of text which is why its always better to make available the list of options in dropdown menu for the users to choose from instead of allowing the users to type in their inputs.The dropdown list of options is easy to implement in Google Docs Spreadsheet which also makes it faster to fill in the details.

Here are the steps to follow to create a Drop Down Menu in Google Docs Spreadsheet :

  • First create the column name and select the column name for which you want to show a list in the dropdown menu.Google Spreadsheet
  • Next In the Column Name Box of the selected column on mouse hovering a new drop arrow should be available, Click the arrow and select “ Validate Data“ from the Menu as also shown in the image below.Validate Data
    Also Checkout :

  • A new “ Data Validation ” Popup window should be presented using which the required data validation list can be set.Under Criteria Menu select “ Items From A List “  Next select “ Enter List Items “ where the required list of inputs which the users can select have to be entered separating each item with a comma as shown in the image below.

    Data Validation Incase you want to allows users to enter data other than the pre-defined list of items, then also Check “ Allow invalid data, but showing warning “.

  • Save the Settings, after which you should have the dropdown menu for each field of the column for which you created the Validation.The image below shows how the  item can be selected from the List.

    Spreadsheet DropDown Menu

Also Read About : Joukuu, A Desktop Client To Access and Backup Files From Cloud Storage Services.

Similar Post  How To Delete Old Restore Points and Save Space

That’s it, you can follow the same steps to create validation with drop down menu option for any column in the Google Docs Spread Sheet.


  1. Yatheender Reply

    good article.. how do i create drop down list where users can perform multiple selections? (Ex: Finance, Marketing, Operations)

  2. Mari Reply

    Is there a way to select multiple options from the list, so that they appear in the same cell either on different lines or separated by commas? Thanks!

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.