How to Create a Drop-Down List in MS EXCEL (Data Validation tool)

Here's how to create a drop-down list in Excel. Actually, Microsoft call the function 'Data Validation'. Not only this, I show you two ways to do it (beginner and intermediate), how to amend that list after, and how to clear the validation. But for the quick answer, go to the 30 seconds mark. This is a handy tool to keeping your data consistent when there are clear categories, avoiding typos or different ways of expressing things. It also makes data entry easier for end users. This is compatible with whatever version of Excel you're using, be it 2016 or 2026. Here's the chapters if you're in a hurry... ____________________________ Chapters 0:00 Intro & Overview 0:30 Quick Answer 0:45 Organise Your Data 1:02 Create Drop-Down Lists 2:26 Remove Drop-Down Lists 2:44 Add New Items to List 3:36 Customise Error Alerts 4:30 Final Tips & Close _________________ I hope you find this helpful. Let me know your thoughts and questions in the comments, I do reply. See my other videos or blogs with more Excel tutorials: https://excelattheoffice.com/blog Kind Regards, Adrian