Validation in Excel

How to do 开发者_运维问答data validation in excel? for example i have data as "P/CST/454" in a cell than how to validate that cell?

Create somewhere in your document, e.g. on a separate config sheet, a list with the allowed values. highlight this range and give it a name (Either type the name in the Name Box, or using on the menu Insert - Name - Define).

Then you have a List of your values that has a name.

Now highlight the cell that you want to have validated. Goto the menu "Data - Validation". In this screen choose from "Allow" the entry "List" and under "Source" enter "=NameOfMyList".

There we are, now only the values from your list can be entered in the cell.

Update:

• It is possible to avoid the Name and enter the Range of your list directly under "Source"
• You can enter your allowed values also directly under "Source" separated by commas. But I would do this only if the list is very short.