Web how to create drop down list from another sheet.
How to create a drop down list in excel based on another sheet. The good news is that identifying a list on another sheet. Then, go to the data tab and click “data validation” in the data tools section of the ribbon. Choose the settings tab in the.
This will open the code window for that. Select the cell or cells where you want to create a dropdown list. By svetlana cheusheva, updated on april 5, 2023.
Web it’s easy and we’ll show you how. Web select the cell where you want the list. Web the data you want to use in an excel drop down list usually won’t be in the same sheet as the drop down.
Let’s look at how to create a.