define acceptable entries value in cell in Excel

Q39. In Excel, how can I ensure that user enters only certain acceptable values in an input cell?

For example, for geographical latitude input the acceptable values can be -90 to +90. Any value outside this range is not a valid latitude. In Excel, how can I prevent users from entering values outside of this range?

To do it in Excel, here is the answer:

a) Select the field for Latitude input. Under "Data" tab, click Data Validation -> Data Validation.

excel define acceptable entries value in cell

b) Select "Decimal" for Allow field (since latitude could be in decimals) and enter "between", "-90" and "90" for Data, Minimum and Maximum fields respectively so that input is restricted to values between -90 and +90. Click OK.

excel excel define acceptable entries value in cell

c) If user inputs a value outside of the range (-90 to +90), error message appears asking user to retry or cancel.

excel excel excel define acceptable entries value in cell

 

You can find similar Excel Questions and Answer hereunder

1) I want to pull data from a table using a reference cell in table. Is there a function to support that?

2) How can I enter a cent symbol in a cell?

3) How can I activate a routine when there is a change in value of a cell?

4) Can I add a Text histogram to Table data to make it visually appealing and easy to interpret?

5) I am considering an investment of $500 per month for 3 years @ 6% interest rate. What is the Present Value of investment?

6) How can I enter a text in a cell with subscript and superscript?

7) How can I identify the cells that influence a particular cell to help with debugging of my spreadSheet or understand a spreadSheet that I inherited?

8) How to read a value from a cell in vba in Excel

9) How can I prevent users from entering duplicate values in a range?

10) How can I update a listbox based on data in a list using VBA?

11) How can I identify the cells that are dependent on a particular cell?

12) How can I find the slab in which a given value fits?

13) how do you enter multiple line in a cell in Excel

14) Can I add a small chart to Table data to make it visually appealing and easy to interpret?

15) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?