O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

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

Validating Data Entry

In ordinary lists or in list objects that have not been linked to SharePoint, you can enforce data-entry criteria by choosing Data, Validation. You can specify the type of data you'll allow (whole numbers, dates, or times, for example), as well as the range of acceptable values. You can even set up a list of allowed values (the names of your operating divisions, for example) and have Excel create a drop-down list of those values. Whoever uses your list can then select a valid entry from the drop-down list.

Note

Data validation rules are not accepted in linked list objects because SharePoint cannot enforce such rules. To set up validation criteria in a linked list object, open the list in SharePoint and click Modify Settings ...

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