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

[Guest]

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.

 

[Guest]

Google "excel data validation"

Dave

 

[Harlan Grove]

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.

I want, I want, I want.

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

 

[Guest]

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

Dave

 

[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