Scribd
Upload
58 views2 pages

Resolution of Data Validation Issue

The document provides a step-by-step guide for resolving a data validation issue in Excel. It instructs users to access the Data Tab, select Data Validation, and then clear all settings in the validation modal. Following these steps will resolve the validation issue.

Uploaded by

Sadanand
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
58 views2 pages

Resolution of Data Validation Issue

The document provides a step-by-step guide for resolving a data validation issue in Excel. It instructs users to access the Data Tab, select Data Validation, and then clear all settings in the validation modal. Following these steps will resolve the validation issue.

Uploaded by

Sadanand
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

1. Click on the Data Tab from the Nav Bar of the excel sheet as shown in the screenshot.

2. Click on the Data Validation from the toolbar of excel sheet as shown in the screenshot.

3. After clicking on the Data Validation, a dropdown opens there as shown. Click on the
Data Validation option.
4. After the previous step, a modal will be opened as shown below.
a. Click on the box to check it as shown in the image below.
b. Then, Click on Clear all.
c. Finally, Click on OK.

The validation issue has been resolved.

You might also like