how to add a drop down list in google sheets

You can also create a validation help text if desired. Be sure to tick Show dropdown list in cell and select Reject input.This will enable us to create a dropdown list showing the five different courses for customers to select from. In the pop-up box, we will select List from a range in the Criteria section and define the range as ‘Master List (Catering)’!B4:F4.Then, we will need to use the data validation feature to create a dropdown list.Simply click on the cell that you want to create your dropdown at. Let us create the first dropdown list.Remember to categorize the remaining courses as well! If you want to put multiple words, input an underscore in between the words instead of pressing the spacebar.

Take note that names inputted can only be a single word. In the pop-up, input the desired name for the range of cells and select the range of cells to be named.

To do this, select Data, then Named ranges. This enables formulas to be easily understood and read.įor example, data within the cells of B5:B9 are named as Appetizers. Second, you will also need to name the different ranges of data. This will enable your Google Sheets to be cleaner and easily navigated. It requires us to utilize several functions in a single formula.īefore you start, it is preferred to create three different sheet tabs for the Dependent Dropdown List, Master List, and Prep Data List. The tedious part that needs more attention is when we are preparing the Prep Data List. How to Use the Dependent Drop Down List Feature in Google SheetsĬreating a multi-row dependent dropdown list in Google Sheets requires: Once the dependent dropdown list is created, we will be able to send this list through email to customers for them to list down all the dishes they want for each event. This enables the customers to dependently select the dishes according to the events and the number of courses they want in an event. Let us create a multi-row dependent dropdown list in Google Sheets containing all the dishes from the menu for customers to select from. This makes it easy to make errors in the order form collected from your customers. In this example, you are an Italian catering company that supplies food for different events.įor customers like event management companies, they have several events lined up that would need you to cater to. A Real Example of Using Dependent Drop Down List Feature

How to add a drop down list in google sheets