Spreadsheet’s data validation helps you prevent the input of incorrect values to worksheet cells. This feature allows a user to define cell value restrictions and provide corresponding error messages. Data validation is extremely useful for ensuring that the entered data to be accurate and consistent when multiple users share a workbook.
This demo displays a simple document with applied data validation. Columns contain validated cells and provide explanatory comments. To view or modify validation settings, select a validated cell and click the Data Validation ribbon button to invoke the Data Validation dialog.