I prepared a spreadsheet where I used the drop down list command in several cells (data validation, list). I needed to provide two versions of the same spreadsheet: one saved as Excel 2007 file, and the other one as Excel 2010 file.
Tables are available in Excel versions 2007, 2010, and 2011. In this post I’ll create a Table to hold the Category’s and Items, create three defined names using dynamic formulas, then use Data Validation to create two drop-down lists, the second being dependent upon the first.
How to create a dynamic dropdown list in Excel and how to edit or delete a drop to create a drop-down box in all versions of Excel 2013, 2010, 2007 and 2003. Select the entries you want to appear in your drop-down menu in an existing.
I used data validation including drop-down lists in the 2007 format of Excel. when i open the workbook in 2003 format, the validation does not work. Please assist in recifying this without having to redo the entire workbook.
Limit choices in an Excel drop down list, based on selection in another cell. Example Dependent Drop Down Lists, Set up the Workbook, Create a Region Dropdown List, Create a These instructions are for Excel 2007, and later versions.