Data Validation

As a default, you can fill in just any text or Number etc. in any cell of your worksheet.
Databases and solutions however demand reliability.  The Data validation feature just does that. For example you might want to dictate the following rules to your electronic measurement book.


Post a Comment

Popular posts from this blog

Using Excel Solver Feature to analyze and optimize the Steel Truss Design.

Project Scenarios-What if Analysis

Using Excel conditional formatting for comparative statements