Microsoft Excel can save you time in lots of little ways, like adding a drop-down list to cells so that only pre-written text can be entered.

We hope you understand how to create a drop-down list using Data Validation in Excel. Data Validation in Microsoft Excel allows users to control the type of data entered into the worksheet.