Excel Dropdown List From Another Sheet - Web now, let’s create a dropdown on another sheet named dropdown and reference animals_list : Select a cell, then select data > data validation. On the data tab, under tools , select data. Create a second sheet and name it dropdown (strictly speaking, it isn’t necessary to name this. Create list of values suppose we would. Select the cells that you want to restrict data entry in. In source, type =my list name. First, we have to create. Web often you may want to create a dropdown list in an excel sheet using values from another sheet.
Create a second sheet and name it dropdown (strictly speaking, it isn’t necessary to name this. Web often you may want to create a dropdown list in an excel sheet using values from another sheet. Select the cells that you want to restrict data entry in. Create list of values suppose we would. On the data tab, under tools , select data. Web now, let’s create a dropdown on another sheet named dropdown and reference animals_list : Select a cell, then select data > data validation. First, we have to create. In source, type =my list name.