Well, now select the cell on which you want to have your list and click on the Data menu from the top menu section of your sheets.
And it’s in column A1:A6, and I want to create a drop-down list of these movie names in column B using a range of cells. For example, see the below attached image. To begin with, you need to have a data sheet on which you want to create a drop-down list. Click OK to see the drop-down list in the workbook. Select the range of cells with items as the Source. In the Ribbon, select Data > Data Tools > Data Validation. Method 1: Create a Drop-down using a Range of Cellsġ. To make a drop-down list from the data contained in a range of cells, start by selecting the cell where you want the drop down to appear. I’ll demonstrate that to you, so let’s start. However both process will work for you, but it has slight differences. Using a range of cells and another is a list of items. You can add a drop-down list in Google sheets in two ways. How to Add Drop-down List In Google Sheets In the entire article, I will walk you through how to add a drop-down list in different ways, how to paste it from one cell to another, and eventually, how to remove it from your Google Sheets. Furthermore, you can create interactive charts and dashboards with drop-down lists. As an example, you can update your to-do list as complete, in progress, not started yet. With Google Sheets, you can create a drop-down list for various purposes.
0 kommentar(er)
