To create a drop-down list, select cell where you want it to be (in this case, cell I2), and in the Data tab on the ribbon, click "Data Validation" in the drop-down option with the same name.

Discover 7 powerful Excel functions that will revolutionize your workflow, automate tasks, and save you hours of time. From ...

Learn how to use Excel FILTER, XLOOKUP, and SUMIFS functions to streamline workflows and make smarter data-driven decisions.

When you work with Excel, you often need to ensure that the data entered into your spreadsheets is accurate and consistent. One effective way to achieve this is by using a drop-down list.