O'Reilly logo

Microsoft® Excel® 2010 Formulas & Functions Inside Out by Helmut Reinke Egbert Jeschke Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, and Jens Bock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Functions for Validation

The validation features on the Data menu (Excel 2003) or the ribbon (Excel 2007 and Excel 2010) offer many possibilities for input control. Among other things, you can limit the input to certain data types and content. It gets really exciting if you use functions for validation—in other words, if you have calculated validation values.

Cell Protection with Validation

The data validation options in Excel offer an invaluable facility for protecting data entry. This is different from the protection facilities that can limit changes to cells with password requirements. Data validation limits data input to a range of acceptable options. You can use data validation to protect cells by using the following technique. After you have ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required