How to create the dropdown in the excel?

Okay. You can achieve this using Macros.

Please refer this: