How To Make Drop Down In Excel. On the first sheet select cell B1. Select Shift cells down and click OK.
This makes your drop-down list case sensitive. Enter your drop down list items in your Excel workbook preferably in a separate sheet to avoid any accidental changes. On the first sheet select cell B1.
It even works for noncontiguous Excel cells.
On the Settings tab select List from the Allow drop-down list see drop-down lists are everywhere. We have Data Validation. Select New rule from the list and a dialog box will appear. On the Data tab click the Data Validation option.