How to Create Drop Down Lists in Cells - The Complete Excel Guide
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/
Видео How to Create Drop Down Lists in Cells - The Complete Excel Guide канала Excel Campus - Jon
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/
Видео How to Create Drop Down Lists in Cells - The Complete Excel Guide канала Excel Campus - Jon
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
How To | Create Dependent Drop-down Lists in ExcelExcel 2016 AdvancedUsing Checkboxes in Excel - Part 1MS Excel - Dependent Dropdown List50 Ultimate Excel Tips and Tricks for 2020Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)Creating Easy Data Entry Forms in ExcelSearchable Drop Down List in Excel (Very Easy with FILTER Function)How to Create a Data Entry Form in Excel With Add, Modify, Delete and Reset (Step-by-step Guide)Top 10 Most Important Excel Formulas - Made Easy!How to Add New Items to Excel Drop-down Lists AutomaticallyHow to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEXINDEX MATCH Explained (An Alternative to VLOOKUP)How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup in ExcelDrop Down Lists in Excel - Masterclass (incl. Dynamic, Dependent & Searchable Drop Down Lists)VLOOKUP Tutorial for Excel - Everything You Need To KnowFully Automated Data Entry User Form in Excel - Step By Step TutorialExcel Drop Down List Including Cell Colour Change: Colour FillExcel IF Formula: Simple to Advanced (multiple criteria, nested IF, AND, OR functions)Date Picker in Excel - The Coolest Little Helper in Excel!