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 ...

Set data validation If you want to insert different task priorities (High, Medium, or Low) and Status (Pending, Ongoing, Skipped, Completed) in your Excel sheet, you need to use Data validation ...

If you’ve used data validation controls, you know how easy they are to add and how helpful they can be. This type of control is truly one of Excel’s most helpful features, because the drop ...

We’ll add two items to the dropdown list, but you can add many more. Now, let’s insert the data validation control. Using the simple demonstration sheet shown in Figure A , click B2.