how to add a drop down list in google sheets

Next, we will select the cells where we want to add our drop-down list.

We will also learn how to create a dropdown in one workbook and move it to a different workbook.įigure 1 – How to make a dropdown in google sheets How to add a drop-down menu in google sheet In this tutorial, we will explore the ways to create or modify a drop-down menu using an Excel data validation list based on a named range, range of cells, list of values and a dynamic drop-down. We use drop-down lists in the Google sheet to enter data from a predefined list of items. How to Split Text to Columns in Google Sheets: Learn how to create drop-down lists in Google Sheets.How to add, edit and create drop-down lists in Google Sheets – Excelchat

Select Show warning to detect invalid data.įigure 6: Example of how to create a drop-down list in Google Sheets.

A list gets created in the mentioned cell in Step 1.

This will include cells in the specified range inside the list only.įigure 5: Information about remaining parameters Step 4: Create a list.

Here I have selected a List from a range as the criteria and mentioned the range from A1 to A6.įigure 4: Cell range for specified criteria.

In the textbox adjacent to criteria, mention the range used.

based on your requirement.įigure 3: Criteria parameter of data validation

You can choose from a variety of criteria, such as a list from a range, list of items, number, text, date etc.

The second parameter in Data Validation is Select Criteria.

Choose cell C1 to create a list only in one cell.įigure 2: Cell Range parameter Step 3: Select Criteria.

Enter the range of cells where you want to implement a drop-down list.

The first parameter in Data Validation is Cell Range.

Navigate to the Data button in the menu bar.

Select a cell where you want to display the list.

How to create a drop-down list in Google Sheets? Step 1: Open Data Validation

Solve this problem by creating drop-down lists, by keeping all the possible valid options a user can choose, thereby removing incorrect inputs. Since sheets are shared across departments, there are times when users might input wrong information in a particular cell.

Google Sheets allows you to create and edit sheets, shared by multiple people at a time. Why create a drop-down list in Google Sheets?

How to create a drop-down list in Google Sheets?.

Why create a drop-down list in Google Sheets?.

How to add a drop down list in google sheets