Follow the steps below to create a drop-down list using data validation in Excel. If you want to add a message pop up, you can click the Input Message tab and check the checkbox for “Show input ...

Microsoft Excel isn't just for work. In fact, by leveraging just three single, powerful formulas, I use the popular ...