Two ways to add a drop down list in Excel. Sometimes you have a sheet that you need other people to fill in. And, you have a column or range of cells that need to have values from a specific set of values. Two ways to add a drop down list in Excel. Sometimes you have a sheet that you need other people to fill in. And, you have a column or range of cells that need to have values from a specific set of values.

A drop-down list is a very handy Excel tool for checking the entered data. The following features of drop-down lists allow you to increase the convenience of data handling: data substitution, displaying data from another sheet or file, the presence of the search and dependency function. Excel also has a feature that allows you to create drop down lists. And today I will guide you on making a drop down list in Excel. How to make a drop down list in Excel: First of all open your excel sheet and select the cell on which you wish to create a drop down. Oct 25, 2018 · IMPORTANT: For the drop down list to work, the workbook which contains the list must be open, in the same instance of Excel, when you use the drop down lists. You could create the list in a workbook that is always open, but hidden, such as the Personal.xls workbook.