When you create a spreadsheet or workbook for users in Excel, you may wish to regulate the information entered into certain cells. Doing so ensures that all data entries are valid and consistent.
Moreover, you may also want to allow the entry of specific data types, such as figures or dates, and restrict numerals to a specific range and the length of text. You may also want to provide a preset list of suitable entries to avoid errors. All these things are possible with Excel Data Validation in all Microsoft Excel versions.
In Excel, data validation is a mechanism that limits user input in a spreadsheet. It is frequently used to restrict user admission. It also allows the user to generate a personalized message if incorrect data is entered.
If you are wondering how to validate data in Excel, you’ve come to the right place. Keep reading to learn the steps of data validation in Excel.
How to Validate Data In Excel?
Step # 1 Select the Cell You Want to Validate
The first step to validate data in excel is the selection of the data cell for validation. You can do this by clicking on the data tab, then selecting data tools, followed by the Data Validation option. You will then see a new data validation dialogue box.
Step # 2 Specification of Your Validation Criteria
The second step is to go to the settings tab and select a table or range to specify your validation criteria.
Step # 3 Selection of Criteria, Under Allow
In the third step, you have to select an option from the list, which includes:
- Date
- Time
- Decimal
- Whole Number
- List
- Text Length
- Custom
Step # 4 Specify the Condition
In step four, based on what you have selected in step 3 for Data and Allow, you have to specify a condition and the required values.
Step # 5 Add the Input or Custom Error Message (Optional)
You can enter an input or custom error message in you want. These steps are optional.
Step # 6 Select Ok
Select OK. You will get an error if you try to input a value beyond the required range.
Final Word
Do you want to optimize Excel spreadsheet dashboards and make powerful presentations? Biz Infograph is here to help.
Biz Infograph is an industry-leading presentation resource provider that seeks to assist business professionals in creating exceptional presentations and staying on top of excel spreadsheet dashboards. They provide many themes for presentations, infographics, and configurable dashboards.
Their clients can browse hundreds of attractive designs and choose the best display of the information needed. The company offers customizable PowerPoint and Google Slide templates, dashboards, and infographics. For more details, feel free to contact us at +14372198199.