To make your Excel worksheet more efficient, use the drop-down list in the cell. It is easy to select from the list instead of typing in each cell particularly. It also saves time. In this article, I have tried to show you how you can easily make a cell into a drop-down list. So Let us proceed with steps of How to Create a Drop-Down List in MS Excel 2016?
Steps to Create a Drop-Down List in MS Excel 2016:
Step 1: In the image below you can see that I have prepared an Excel sheet which contains Sr no., Name and City columns. Now I want to create a drop-down list for the City column. I have also prepared the list of cities which I want in the drop-down list in the same Excel sheet. If you want, you can prepare the content of drop-down list in the separate sheet also.
Now, select the cell to which you want to convert into a drop-down cell.
Step 3: A Data Validation Dialog box is opened. Under Settings tab, you have Allow: drop down box click it and among the options select List.
Step 6: Now you can see that the cell you selected in step 1, is converted to a drop-down cell. Click on the drop-down arrow that appears on the right-hand-side of the cell and the entire drop-down list will appear.
The other method to apply data validation to the other cells connected to data validated cell is, select the cells including the data validated cell. Go the Home tab, Under Editing group you have Fill drop-down button. Click Fill button and as I have selected the cells in the vertically downward manner, I selected Down. If you have selected the cells in horizontal, you can choose Right or Left according to your requirement. In this way, you can apply data validation to adjacent cells in bulk.