How to restrict a user to enter certain pre-defined values in a particular cell ?

Question

I want to send an excel sheet to a someone else who has to populate few cells with years ranging from 2010 to 2015. I want the cell only to accept a value in the cell as 2010, 2011, 2012, 2013, 2014 or 2015. How to do it?

J V Pavan Kumar · Answer

Yes . . as Prakash said and in addition to that beow are the steps to follow.
1. You have to select those cells where you want to see the values (like 2010, 2011, etc) and
2. Go to Data and select data validation
3. Select "List" and in the "Source" give the values you want to see in the selected cells (like 2010, 2011, etc.) and click OK.
4. In the selected cells you will get dropdown list, and if you try to enter any value apart from the list it will through an error.

Hope this would answer what you are looking for. Have a nice day.

Regards,
Pavan

Vinod Tiwari · Answer

Using Datavalidation

Prakash Sagar · Answer

...use Data Validation.... with offset function if you think you would have to add more items to the list!!! Cheers

Pooja Chotelal Kushwaha · Answer

You can use Define name range and call it in data validation. Also you can make year list dynamic - means if you add year it will be added to list automatically(Use table formate).

Jaimin Trivedi · Answer

Data Validation is used for protecting the data from getting edited or tampered. Now as you mentioned that you want to restrict a user to enter certain pre-defined vakues in the particular cell so that can be done by data validation. First of all select the cell where  you want to to restrict the data values. Say B2. Select data validation under data tab. Under settings tab, Select as Whole number in allow list. Then select as between option in data list. Write Minimum value as 2010 and maximum value as 2015. Press ok. Now that particular cell will only accept values between 2010 to 2015 and rest all values will be restricted. This is how the data validation is done.

Abhishek Anand · Answer

Through data validation. (Creating rules)

Ankita Mishra · Answer

By data validation