![]() |
Leading the way in Microsoft Office Development |
| Home | | | Excel | | | Word | | | PowerPoint | | | Consultancy | | | Feedback | | | Contact |
| Microsoft Excel > Data Validation > Getting Started | | Next > |
What is Data Validation ? |
The main purpose of data validation is to create restrictions on the type of data that can be entered in a cell. | ||
Very useful for preventing the entry of incorrect data or data that does not meet a particular criteria. | ||
Data Validation only restricts the data that is entered - the cells can still be deleted or pasted over. | ||
Data Validation is a way to validate your data without doing any actual programming. |
![]() |
What can you use Data Validation for ? |
1) For restricting the type of data that can be entered in a particular cell. | ||
2) To provide a drop-down list of values that can be entered in a particular cell. | ||
3) Displaying a descriptive prompt to remind users what type of information should be entered in a cell. | ||
4) Displaying an error message if the user enters an invalid value in a cell. | ||
5) Prevent a value appearing more than once. | ||
6) numbers within a specific range. | ||
7) a certain number of characters to be entered. |
Using Data Validation |
This can be found by selecting (Data > Validation). |
Using Named Ranges |
Things to Remember |
If you copy a cell and paste it over a cell that has Data Validation applied to it then the validation will be lost without a prompt. | |||
You can copy data validation from one cell to another by using the (Edit > Copy) and (Edit > Paste Special) dialog box. | |||
If you want to apply data validation to a large block of cells, it is easier to add the data validation to just one cell and then copy and paste the data validation using the Paste Special dialog box. | |||
These rules only apply to data that is entered into a cell manually and does not work on data that is pasted into cells using a macro ?? |
| Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved. | Top | Next > |