In this tutorials, we’ll learn how to use Data validation function to restrict or warn user about the data. For users under training about the work on worksheet, can be provided with Data validation Error messages. So whenever they do something that’s not allowed, get explained which Worksheet rule they’ve broken. Let’s start with the worksheet:Validation error 1


We’ll apply data validation error on Column C. For that, select the whole column C.

Validation error 2

Go to “Data” tab and select “Data Validation”.

Validation error 3



A pop up will appear. Select “Error Alert” tab.

Validation error 4

There is “Style” option, “Title” and “Error message”. “Stop” Style will restrict the user to enter invalid data. In the Title, we’ll enter “Invalid Age” and in Error message, “Age must be in the range of 17 to 100”. And click “OK”.


Now returning to sheet, if you’ll enter invalid data. It’ll prompt an error message.

Validation error 5

This option will restrict the user to enter the valid data.



If we select “Warning” Style, it’ll prompt a warning message that will ask you to confirm if the data enter is correct or not.

Validation error 6



If we go for “Information” style, it’ll prompt an information dialog about the data validation.

Validation error 7


In this way, you can set Data validation Errors, Warnings and Information about the data and the make a worksheet with the data rules.

Leave a Reply