How to create dropdown list in Column, Cell – Google Sheets

How to create dropdown list in Column, Cell

If you are using Google sheets then this topic – How to create dropdown list in column, cell – Google Sheets is helpful and time saving. In sharing spreadsheets you can restrict users using drop down menu so that they can enter data as per need and validate.

How to create dropdown list in Column, Cell

This is the easy of google sheet that you can create drop down menu for the whole column or single cell or couple of cells. I am going to show you how to create drop down list for 10 cells. For this open google sheet and select the cells where you want to create data validation.

How to create dropdown list in Column, Cell

Next go to Data in the menu bar and select data validation.

How to create dropdown list in Column, Cell

In the criteria select List from range or List of items.

How to create dropdown list in Column, Cell

List from range – If you want to use same values which are used in other cell in the same sheet or different then select List from Range. And the data present in the cell appear in the drop down list.

List of items – Its a list of predefined items. It can be numeric, alphabetic and type every item with comma without space. In this post I am using List of items. In the below you can see input item with commas and no space.

How to create dropdown list in Column, Cell

After filling items, enable Show drop-down list in cell so that drop down option will appear in the cell.

Next point is On invalid data select what type of response you want to show if user selected wrong value or input which is not on the list.

Show warning – It shows only red mark on cell if entered input in the cell is not in the list.

Reject input – In reject input a pop up will come that the input is violating the data validation set on the cells. Please choose from the following list.

How to create dropdown list in Column, Cell

In the last mark Appearance and enable the Show validation help text so that user get indication of choosing item from the option provided in the drop down menu. You can create custom instruction with this option.

How to create dropdown list in Column, Cell

And click on save for validating data. If you want to remove data validation then same process go to Data >> Data Validation and click on Remove Validation button in the bottom of box.

This is all about creating drop down list in Google sheet for making for work easy and fast. If you are facing any issue please comment below.

 

Author: akshay upadhyay

He is an Entrepreneur and Professional Blogger, who has tremendous passion for innovative application and developing them, like Video Waker. You can follow him on Google Plus.