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.

Using Excel conditional formatting for comparative statements

Using Excel's Forecast Sheet Feature for Construction & Life Cycle Parameters