Excel Drop Down List VideosCreate a drop down list of items in a cell, with Excel's Data Validation feature. This will make data entry easier, and reduce input errors and typing mistakes. The two videos below show the steps for making a basic drop down list in an Excel worksheet cell. |
Create a Drop Down List in ExcelTo 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. Watch the steps in this short video tutorial, and for written instructions on how to create a drop down list, see Excel Data Validation - Basics. |
List on Different SheetIf you prefer not to create a named Excel table, you can create a named range, and use that as the source for a drop down list. The drop down lists can be on the same sheet as the source list, or on a different sheet. Watch this video to see the steps, and see the written instructions see Excel Data Validation - Basics |
Next: Dependent Drop DownsOn the next video training page, see how to create dependent drop down lists with Excel Data Validation. For example, select Vegetable in column B, and see a drop-down list of vegetables in column C. Click this link to go to Dependent Drop Down Videos page. |
Last updated: November 19, 2022 3:29 PM