Excel Spreadsheets - Develop and Validate to Eliminate 483s 5 November 2010, Palo Alto, United States Introduction Learn how to Use excel spreadsheet for GXP data and reduce validation cost and time.

Learn how to Use excel spreadsheet for GXP data and reduce validation cost and time. Configure Excel for audit trails, security features, and data entry verification.

Learn how to create a drop-down list in Excel without or with color using conditional formatting and data validation rules.

How to base a data validation dropdown on an array in Excel Now we’re ready to create the data validation dropdown that will display the unique list in column H.

Use Data Validation in Excel You can use Excel's data validation to make sure that people only enter a certain type of data, such as a date, in a particular cell.

This article provides step-by-step instructions for color customizing your drop-down list in Microsoft Excel.