629 views
Maybe it has happened to you that you have sent an Excel file to someone to fill. But that person filled the file with wrong values. For example, text is written where a number should be entered. To avoid these problems, the Data Validation tool can be used so that the user is allowed to enter only certain values.