Data Validation in MS Excel

Data Validation in MS Excel

Data validation is a feature available in Microsoft Excel. It allows you to do the following:

  • Make a list of the entries that restricts the values allowed in a cell.
  • Create a prompt message explaining the kind of data allowed in a cell.
  • Create messages that appear when incorrect data has been entered.
  • Check for incorrect entries by using the Auditing toolbar.
  • Set a range of numeric values that can be entered in a cell.
  • Determine if an entry is valid based on calculation in another cell.

Leave a Reply

Your email address will not be published. Required fields are marked *