Press "Enter" to skip to content

Drop-down menu In Google Sheets/ How to Create One

Drop-down menu is a list box that appears When a button is clicked, that enables users to select from the options presented. Creating a drop-down list in Google Sheets is not as difficult as people thinks, in this article you will get the full process.

Drop-down menu

How To Create A drop-down list on your computer

  • Open a spreadsheet
  • Navigate to choose the cells you want to add a drop-down menu to
  • Press on “Data” in the menu on the top of the page
  • From the drop down menu, select “data validation” button
  • When you select List from a range, the list of values retrieved from a particular cell range,pops out. Then if you select “list of items” a menu of text values keyed in the edit field, will display. When you click on number it validates that items entered falls within a numeric range. The text tells when an entry has or does not contain a specific string of text.
  • To remove the down arrow in the cell, Uncheck
  • You will receive warning, when you Key in a data that is not corresponding to an item.  Choose “reject input” tab, if you want people to type in items from the list.
  • Tap on “save”

How To Change or Delete a drop-down menu

  • Open a spreadsheet
  • Locate the cell you want to delete
  • Tap on “Data” tab
  • Select “data validation”
  • To change, Go to criteria and edit items next to it
  • To Delete a list, Press on “Remove validation” button.
  • Click on “save

Create a drop-down menu on Android device

  • Go to Google Sheets app
  • Open a spreadsheet
  • Tap on “cell or cells”  you want to add a drop-down list to
  • Move to the top of the screen and click on “more” icon
  • Select “data validation” widget
  • Go to criteria and select an option, so if “list of items” is selected, to add items, Press on “+” sign, then tap “done” to save. When you select “list of range” you type in the cell to be included in the list
  • In the cell, there will be a down arrow, so to remove it disable the switch beside show drop-down list in cell
  • The two options shows warning when you enter an invalid data and rejects users input altogether
  • Click on “save” widget 

To Modify Or Remove a list with Android device

  • Select the cell that contains the drop down list that you want to change or delete
  • Tap on “more ” icon, represented with three dots at the top of the screen
  • Choose “data validation” tab
  • If you want to change the items list, simply Move to criteria and edit
  • If you want to delete,  Navigate downward and click on “Remove rule” widget
  • When you are satisfied with the changes, you can select the “save” widget to save changes.

Be First to Comment

Leave a Reply

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