First of all, you have to create named ranges for drop down lists For this, select product list Go to >Drop Down from Filtered List With Excel data validation, you can create drop down lists, to make data entry easier In this example, some employees will be on vacation, and their names will be omitted from the drop down, when the employee list is filteredStep 3 Create a Drop Down Now we can create the drop down Select the cell for your drop down, and select Data >
How To Edit Dropdown List In Excel 16 With Images Quehow
