How to

How to use data validation in excel?

In this article, we will do our best to help you with your Excel related inquiry. In fact, in our goal is to help you find answers to your questions. For now, we would like to help you answer the following question: "How to use data validation in excel?". So here we go!


How to use data validation in excel?

1. Choose the cell or cells for which you wish to construct the rule.
2. Select Data >Data Validation.
3. Choose one of the following options under Allow on the Settings tab:
Whole Number, Decimal Number, List, Date, and Time, and the Length of the Text
4. Choose a condition to work with under Data.
5. Configure the remaining mandatory values in accordance with the options you selected for Allow and Data.
6. Click on the tab labeled "Input Message," then edit the message that end users will see while they are inputting data.
7. If you tick the option labeled Show input message when cell is chosen, the message will be displayed whenever the user chooses or hovers over the cell that is now selected.
8. Click on the Error Alert tab to make adjustments to the error message and select a format for the message.
9. Make sure you click OK.


MS Excel - Data Validation


Data Validation in Excel - A Guide




How do I use data validation in a drop-down list in Excel?

  1. Choose the cells in which you want the lists to appear by selecting them.
  2.  To validate the data, select DATA > Data Validation from the menu on the top.
  3.  Adjust the Allow to List setting in the dialog box.
  4.  Click the "Source" button, then type the text or numbers (with commas in between each item for a comma-delimited list) that you want to appear in the drop-down menu, and then click the "OK" button.


How do you create a data validation formula in Excel?

  1. Choose whatever cell or cells you want to verify.
  2. Launch the dialog box titled "Data Validation." ...
  3. Choose Custom from the drop-down menu in the Allow box of the Data Validation dialog window's Settings tab, and then type in your own data validation formula in that window's Formula box.
  4. Select the OK button.


What are the 3 types of data validation?

Validation of the data type;

validation of the range the restrictions;

Validation of the data type; validation of the range

Validation based on a systematic design, as well as

Validation based on a systematic design, as well as


How do you validate a calculation?

• Verification of the allowable range as well as the constraints;

• Checking that the code and all of the cross-references are right.

• Verification that the data type is accurate.

• Validation in accordance with a systematic design, and

• Confirmation that the consistency has been tested at many points during the process.


How do I apply Data Validation to entire column?

  1. Make sure the whole column that has to be validated is selected.
  2. Navigate to the Data tab and select the "Data Validation" option.
  3. Select "List" from the drop-down menu located in the "Allow" box.
  4. Select the cells that have the permissible values by clicking on the arrow to the right of the "Source" box and then selecting those cells.


Why do we need data validation?

  1. Make sure that the selection spans the entirety of the column that needs to be validated.
  2. Click the tab labeled Data, then choose the "Data Validation" option from the drop-down menu.
  3. Choose "List" from the submenu that appears when you click the drop-down arrow in the "Allow" box.
  4. After clicking on the arrow that is located to the right of the box labeled "Source," select the cells that contain the values that are allowed before moving on to the next step.


What are data validation rules?

Data validation rules are. The data validation criteria determine whether constants, such as any whole integer between 0 and 9, or one of multiple values from another portion of the spreadsheet, can be inserted into a column.


Wrapping Up

We hope this article has explained everything you needed to know about "How to use data validation in excel?". If you have any other questions about the Ms Excel software, please take the time to search for additional Excel content in Otherwise, don't hesitate to reach out to us through the contact page.

Back to top button