How to Use Data Validation in Google Sheets

Google Sheets is one of the Free spreadsheet apps Popular. Its web-based nature makes it easy to collaborate on a spreadsheet with multiple users. However, having multiple users working on a spreadsheet together can lead to data entry and formatting issues. One way to manage input in a spreadsheet is to use data validation rules to restrict the information you can enter into a cell.

With data validation, you can also provide guidance on what to enter in a cell. At the same time, it can also give others a warning or error message when they enter incorrect data in a cell. Here's how to use data validation in Google Sheets.

How to set up a data validation rule in Google Sheets

Using data validation, you can specify the type of data entry you want in a cell. For example, you can specify a cell to accept only a number, date, fraction, etc. You can also create a drop-down list using data validation. Here's how:

Step 1: Open Google Sheets in your favorite web browser.

Open Google Sheets

Step 2: Create New work Enter your own dataset or open an existing workbook with a dataset.

Step 3: In the spreadsheet, select cells To add data validation rules.

Step 4: tap on Data list above.

Step 5: Locate Verification Verify the data to enable the sidebar on the right side of the sheet.

Step 6: From the sidebar, click the button. Add a base.

Step 7: In a field “Application on the scale”Confirm the range of cells to which you want to apply the data validation rule.

Step 8: Click the drop-down menu below the Criteria field and select Data restriction criteria Your favorite from the following collection:

• dropping
• نص
• Date
• greater than, less than, equal to, or in between
• check box
• Custom formula
• Nobody

Step 9: Enter Values Or a formula to measure your criteria.

Step 10: Click Done to save the changes.

How to add input messages to validate data in Google Sheets

While setting up a data validation rule, you can include an input message. You can also include an input message after setting up a data validation rule. Input messages inform users of the type of input expected in a cell. Here's how to add an input message in Google Sheets:

Step 1: In the spreadsheet, select cell which you want to include an input message in.

Step 2: in the bar Google Sheets, Click the tab data.

Step 3: Locate Verification From Data Validation to launch the sidebar on the right side of the sheet. If you already have a data validation rule in your worksheet, you'll see it listed in the sidebar.

Step 4: Select your existing data validation rule if you want. Add an input message.

Step 5: Click Advanced Options.

Step 6: Check the box next to Show help text for the selected cell.

Step 7: Type Text Which you want to show next to the cell.

Step 8: 1. If the data is invalidSelect Show Warning.

Step 9: Click Done to save the changes.

How to Reject Data Entries Using Data Validation in Google Sheets

You can set up a data validation rule to reject invalid entries in a cell. Here's how:

Step 1: In a Google spreadsheet, select cell which you want to restrict data entry.

Step 2: Click on the menu data above.

Step 3: Select Verify Data validity To turn on the sidebar on the right side of the sheet. If you already have a data validation rule in your worksheet, you should see it listed in the sidebar.

Step 4: Select your existing data validation rule if you want to add one. Input message to her.

Step 5: Click Advanced Options.

Step 6: Check the box next to Show help text for the selected cell.

Step 7: Type Text Which you want to show next to the cell.

Step 8: 1. If the data is invalidSelect Reject Input.

Step 9: Click Done to save the changes.

How to remove data validation rules in Google Sheets

Here's how to remove a data validation rule from a cell in Google Sheets:

Step 1: In a Google spreadsheet, select cell from which you want to remove data validation rules.

Step 2: Click on the menu data above.

Step 3: Select Verify Data validity To turn on the sidebar on the right side of the sheet. If you already have a data validation rule in your worksheet, you'll see it listed in the sidebar.

Step 4: Hover over the data validation rule to reveal the icon. Deletion.

Step 5: Click the Delete icon to delete the validation rule. You can also click the button Remove all If you want to delete all data validation rules in the spreadsheet.

Lock cells in Google Sheets

Applying data validation rules to Google Sheets is one way you can manage data entry. However, if you want to prevent data changes, you can Securing specific cells In the book.