Case 0: No Validation
The default case is that no data validation will be performed. To set this case, if it not already selected, please do the following.
- Right-click on a cell in the row you want to validate and choose Data Validation from the context menu.
- The Data Validation wizard will appear as shown below.
- Select the Open radiobutton if it is not already selected as shown below and then click Next.
- The Finish screen will display as shown below. Click Finish.
- The No Validation case has now been set for this row.