Microsoft Excel is one of the most widely used tools in organizations. Whether you’re an engineer or a data scientist, at the end of the day, you need Bahrain B2B List to have numbers on an Excel sheet to showcase your work. Among many other features of Excel, data validation is one of the common features to use in a team or group environment. For example, you can send an Excel to all your colleagues to fill in from the restricted values. This will help you avoid typing free text and render data in a specified scope. In this article, let’s explore how to create data validation in Microsoft Excel with various options. Related: How to fix slow Excel and speed up your work?
Define Validation Rules
Cells under the “Subject 1” column must be a number. The allowed value is between 0 and 100. It cannot be text less than zero or greater than 100. Excel should automatically reject all other entries. You can set data validation rules in Excel by following the steps below. In order to define these validations, first select the range of cells whose values you want to restrict. In our example, we select cells D4 through D7. Go to the “Data” tab and select the “Data Validation” option in the “Data Tools” group. Creating a Data Validation Rule in Excel Creating a Data Validation Rule in Excel This will open the “Data Validation” dialog box. You can configure allowed entries for selected cells on the “Settings” tab of the dialog box.
Validation Rule Error
Click the drop-down menu under “Allow:” and select your preferred value. In our example, we will select the whole number for the notes. Excel data validation settings Excel data validation settings In the “Data” list box, you can define validity conditions. This limits the possibilities of input and we select the option “between” because we must only allow values from 0 to 100. Remember that the options will change depending on your selection. For example, if you select “greater than”, you will only see a text box to enter a “Minimum” value. For the “between” condition, you can determine the possible range in the “Minimum” and “Maximum” boxes.