Data validation in Excel is a handy tool. It allows the user to control the specifics of what information is able to be entered into a worksheet. This can help ensure that data is within expected ranges, and that the user enters data that will work in a formula.  For example, ensuring that sales are never entered as negative values, or ensuring that words aren’t used in a cell included in a simple formula (12200 + 17090 + “March” + 1820 = …. ).

More →