Data Validation 1: Control User Choices With Lists In Excel
Have you ever needed to create drop-down lists or otherwise control the type of data that users enter on a worksheet? Drop-down lists provide one form of data control by forcing users to select only the items that you provide. But drop-down lists are only part of a larger Excel feature called data validation. Data validation is the process of applying rules that restrict what users can enter on a worksheet. This white paper explains how, and it introduces a larger feature called Data Validation.