Excel validation list from other sheet


Jan 24, 2017 · It’s easy to add a drop-down list to a cell in Excel, but the process is not intuitive. Drop-down lists are created using the Data Validation feature. We’re going to create a drop-down list with a selection of age ranges to show you how it’s done. To begin, enter the list of age ranges into sequential cells down a column or across a row. Jun 07, 2015 · Excel Data Validation Lets say we want to create a drop down box that only allow users to choose fruit name. Create a worksheet named “data” in which we put our Combo Box values inside, type the fruit name in column A. 5. Select the drop down list in cell Q2 in the dashboard worksheet. The number of months has increased to 12. Based on the above example, the number of months in the data validation list will decrease if you delete some values from the range B2 to B13 on the list worksheet. Therefore a data validation list has been created, allowing flexibility ... Collaborate for free with an online version of Microsoft Excel. Save spreadsheets in OneDrive. Share them with others and work together at the same time. Reference Data Validation List On Another Worksheet Apr 22, 2008. I have a spreadsheet in Excel 2003 with many sheets all of which need to have for some columns the data entry restricted to a specific list.