What is data validation in Excel ? Why do you go for that? What ar

R

Rajeswari

I want ageneral description of validation and the criteria for validation.
I am using office 2003 professional
The result i want should be inthe form of precise definition type.
 
H

Harlan Grove

Rajeswari said:
I want ageneral description of validation and the criteria for
validation. I am using office 2003 professional The result i want
should be inthe form of precise definition type.
Click to expand...

I want, I want, I want.

What's insufficient about the way online help explains data validation?
 
D

Dave F

What's insufficient is that requires effort. Easier to be fed information
than to do the cooking yourself!

Dave
 
G

Gord Dibben

This from Excel Help on "validation".

In many worksheets that you create, users will enter data to get the desired
calculations and results. Ensuring valid data entry is an important task. You
may want to restrict data entry to a certain range of dates, limit choices by
using a list, or make sure that only positive whole numbers are entered.
Providing immediate help to instruct users and clear messages when invalid data
is entered is also essential to make the data entry experience go smoothly.

You can re-word it to your precise specifications.

For criteria see Help on "prevent invalid data entry"


Gord Dibben MS Excel MVP
 
Top