Data Validation : Microsoft Excel 2003

File

Edit

View

Insert

Format

Tools

Data

Window

- Introduction - - Parts of Microsoft Excel Window - - Functions used in Microsoft Excel - - Custom List - - Goal Seek - - Error Checking - - Groupping/Ungroupping cells - - Forms - - Data Validation - - Filters - - Sorting - - Freeze Panes - This option sets the validation to the cell. The validation means it will accept only the value according to the given conditions like, only text value, whole numbers, numbers with decimal places etc. It will not accept the value if entered value is out of the specified condition.
Suppose if want to enter only values from 0 to 100 in the cells.
-Selects the cell or cells
-Data – Validation (This will open a Validation Dialog box with three tabs.)
Setting – to set the valid condition and values.
Input message – this is the message that will show every time when we enter in the cell, it is just like a comment.
Error Alert – this is the alert message, which will be shown if the wrong value is entered.)
Select the Settings tab
-Select the Whole Number option form the Allow dropdown list
     -Select Between option from Data dropdown list
     - Fill 0 in Minimum and 100 in Maximum boxes
     -and press OK