Get more Excel tips How to add color to an Excel drop-down list If you’ve used data validation controls, you know how easy they are to add and how helpful they can be.

Learn how to use data validation to create drop-down lists in Excel. Improve your data quality and consistency, and save time and avoid errors.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.

In this article we will show you how to display multiple columns in a validation list in Excel. We will show you a method that can then be applied to your data.

The Excel JavaScript Library provides APIs to enable your add-in to add automatic data validation to tables, columns, rows, and other ranges in a workbook. To understand the concepts and the ...