Check that range is correct as displayed in the refers box and click OK.įigure 8 – Google sheets lists based on named range In the Name Manager dialog, we will click New, and type desired name for entries.Then we will go to the Formula Tab and tap Name Manager.įigure 7 – Insert cell reference for making google sheet dropdown list Next, we will create a named range by selecting all entries and right-clicking.Sort Entries first in the manner we want them to appear in the future.Suppose we have an entry of i ngredients we need some time in the future, we may: If we wish to remove the arrows, we will uncheck “show the dropdown list in cell”.įigure 5 – Make a dropdown list in google sheets Creating a Google sheet drop-down list based on a named range Next, the cells will now have a down arrow.List from the range: Select cells that will be included in the listįigure 3 – Dropdown list using a list of items.List of items: Enter items using commas with no space.In the Criteria option, we will select either:.Now we will click Data, then Data validation.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 add, edit and create drop-down lists in Google Sheets – Excelchat