Excel’s dropdown lists are rightly categorized under the Data Validation tab, as they not only streamline data entry but also enhance the reliability of your formulas.

Go to the ‘ Data ’ tab located on the Ribbon menu. Under the ‘ Data Tools ’ select ‘ Data Validation ’ option. When the Data Validation window opens, you’ll see several controls.