Video Drop Down Lists. Step 1 Open the Excel spreadsheet file you want to edit. How to Create a Drop-down Data Validation List To create a drop-down list start by going to the Data tab on the Ribbon and click the Data Validation button.
You can find and double-click a saved Excel file on your computer or open Microsoft Excel and create a new worksheetStep 2 Enter the list of values for your drop-down in a column. In this video see how to set up dependent drop down list. This module takes you through creating and applying data validation as.
Then select Fruit or Vegetable in the first column and the dependent drop down will only show matching items.
Data Validation Dialogue box appears as follows. How to Create a Drop-down Data Validation List To create a drop-down list start by going to the Data tab on the Ribbon and click the Data Validation button. The few steps described in this video can greatly simplify the process of organizing and filling information in your Excel spreadsheets. This module takes you through creating and applying data validation as.
