Data Validity

Data Validity helps you control what can be entered in worksheet cells. It provides the tools you need to restrict input by rules, reduce entry errors, and standardize data formats, making your work more efficient and helping you accomplish tasks with ease. With Data Validity, you can create drop-down lists, limit entries by type such as whole numbers, decimals, dates, and times, define minimum and maximum ranges, choose whether to ignore blanks, and apply updates to other cells with the same settings. You can also set input messages and error alerts, including styles that reject invalid entries, show warnings, or display information. Whether you're managing collaborative data entry or batch updating existing validation sources, Data Validity helps you stay productive and complete tasks efficiently. Choose the documentation below that best matches your needs to learn more.

1:53