CODEWITHSUNDEEP
excel
comkalp
comkalp

Reputation: 63

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?

Upvotes: 0

Views: 289

Answers (1)

stema
stema

Reputation: 92976

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.

Upvotes: 2

Related Questions