Scribd
Upload
4 views2 pages

Data Validation Examples

The document provides examples of various Data Validation types in Excel, including whole numbers, decimals, lists, dates, and custom values. Each worksheet demonstrates specific validation criteria for data entry, such as limiting entries to certain ranges or formats. It serves as a guide for applying Data Validation to enhance data integrity in Excel spreadsheets.

Uploaded by

Shahwali Khan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Data Validation Examples

The document provides examples of various Data Validation types in Excel, including whole numbers, decimals, lists, dates, and custom values. Each worksheet demonstrates specific validation criteria for data entry, such as limiting entries to certain ranges or formats. It serves as a guide for applying Data Validation to enhance data integrity in Excel spreadsheets.

Uploaded by

Shahwali Khan
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel Data Validation Examples

The following worksheets have various completed Data Validation examples as mentioned in the following Sup

See more online: Apply Data Validation to cells

Each worksheet is listed below, along with what kind of Data Validation you'll find

Worksheet Data Validation Type


Whole number Limit entries to whole numbers
Decimal Limit entries to decimal (percentage) values
Departments Limit selections to list choices
Cost centers table Table for Cost center list source
Cost center budget Limit selections to Cost center list choices
Date Limit entries to dates within a range
Time Limit entries between a time frame
Text length Limit entries to a certain number of characters
HR Budget Limit entries to a certain maximum amount
Products Require entries to meet certain text guidelines
Age verification Limit entries below a certain age
Custom values Limit entries to unique values only (no repeated entries)
E-Mail Require entries to contain the @ symbol

• Cells highlighted like this are for input:


Input here
mentioned in the following [Link] article:

• Data Validation is limited to the following options:

Picture

You might also like