In this video you will learn how to create drop down lists in cells in Excel. These are also referred to as Data Validation Lists. The drop down lists allow the user to select from a drop-down menu of items and input the value in the cell. Download the practice Excel file: https://www.excelcampus.com/tips/data-validation-drop-down-list/
Drop-down lists in cells are great for data entry or inputs for interactive financial models.
I explain how to:
- Create the drop down list from a comma separated list.
- Create the drop down list from a range of cells.
- Use keyboard shortcuts to select items from the list.
- Copy or apply the drop down lists to other cells.
- Handle errors and invalid inputs.
- Add new data to the source range and update the list.
Compatibility: Data validation drop-down lists are available in all versions of Excel including Excel 2003, 2007, 2010, 2016, 2019, Office 365 for Windows and Excel 2011, 2016, and beyond for Mac.
The Free List Search Add-in:
Unfortunately we can't directly search the drop down lists within Excel. So I created a free add-in called List Search that allows you to search any drop down list and input the value in the cell.
It's packed with additional time saving features. Click the link below to learn more and download List Search.
Download The List Search Add-in: https://www.excelcampus.com/vba/search-data-validation-drop-down-lists/
Other Videos and Resources:
- How to create Dynamic drop-down lists: https://youtu.be/RLLdY37YUgs
- How to search drop-down lists: https://youtu.be/kntHn2J7pdk
- Update to List Search Add-in: https://youtu.be/igPO79uYoGg
- Dependent Cascading Drop Down Lists: https://www.excelcampus.com/tables/dependent-drop-lists/