To create a drop down list in Excel 2010, you can name a list of items, based on a named Excel table.
Then, use that list as the source for the Data Validation drop down list.
In the example shown above, the drop down list is based on a range named Products.
Refer to a Source List on a Different Worksheet Use Dynamic Lists Item Limit in Drop Down List Drop Down List Opens With Blank Selected Video: Dynamic Range Data Validation Font Size and List Length Data Validation List With Symbols Scroll Through a Drop Down List Data Validation Dropdowns and Change Events Missing Arrows Valid Entries Not Allowed Invalid Entries are Allowed -- Video: Ignore Blank in Data Validation Data Validation on a Protected Sheet Data Validation Dropdowns are Too Wide Make the Dropdown List Temporarily Wider Make the Dropdown List Appear Larger To create a drop down list in a worksheet cell, use Excel's data validation feature.
If you’re a big Excel user, then you may have found yourself in a situation where you wished you could have simply picked a value for a cell from a dropdown list of choices rather than having to copy and paste text between cells.
For example, let’s say you have an Excel sheet for your own personal budget and every time you enter a transaction on a new row, you type in whether its income or an expense.
To download the sample file, click here: Remove Blanks With Dynamic Range Sample File Why does this happen, and how can you prevent it?
Also, if there are blanks in the source list, invalid entries might be allowed in the cells.