Microsoft excel help

This query is : Resolved

Guest

Guest (Querist)

22 January 2012 Dear experts, is there any function for the following: I want to put either of the 10 characters? like the ans of a cell come with, a b c d e f g h i j! no other alphabet should come... ?

CA Suraj Lakhotia

CA Suraj Lakhotia (Expert)
Follow

22 January 2012 You can use data validation technique for same.
1.Type a-j in a column.
2.Go to the "destination cell" and select data validation from tools menu/data tab.
3. Select "List" in "Allow" field under the setting tab.
4. Give reference to the cells where you had typed a-j and the cell is now restricted.

You can also customise the input message and error message.

Message likes : 1 times