How to turn off data validation in Excel.
By
SpreadCheaters
This step-by-step tutorial will show you how to disable data validation in Excel. Here, we have a sample data set. It consists of columns such as Product ID, Product Name, Region, Sales Rep, and Sales Amount. Here Data Validation is applied to the Region column. This tutorial shows how to remove data validation for the Region, enabling greater flexibility in data entry and analysis.
Excel is a powerful spreadsheet program that is widely used for data analysis, organization, and calculations. It has several features that help to improve data integrity and streamline workflows. Data validation is one such feature, which allows you to define rules for cell inputs, ensuring data accuracy and consistency. However, in some cases, you may need to disable or remove data validation from specific cells or ranges.
Step 1 – Open the Spreadsheet:
– To open Excel, click on the Excel icon on your desktop or type “Excel” into your computer’s search bar and press enter.
– Open Excel and select “File” > “Open.” Navigate to the location of the sales data file and click Open.
Step 2 – Locate and select the Data Validation Cells:
– Scroll through the spreadsheet to find the cells that have had data validation applied to them.
– Here, we’ve a column i.e. Region, in which data validation is applied. No value other than East, West, South, and North can be entered in this column. It will give an error if any other value is entered in this column.
– We will remove data validation for the Region column, enabling greater flexibility in data entry and analysis
Step 3 – Launch the Data Validation Dialogue Box:
– Click the “Data” tab on the Ribbon at the top of the window while the cells are selected.
– Click the “Data Validation” dropdown button under the Data Tools group.
Step 4 – Turn Off Data Validation:
– If it isn’t already selected, select the “Settings” tab in the Data Validation dialogue box.
– Select the “Clear All” button located at the bottom of the dialogue box. All data validation rules that have been applied to the chosen cells will be deleted.
Step 5 – Save the Changes:
– After clearing all Data Validation rules, Click on “Apply”.
– Doing this will save the changes.
– You can repeat the same process for other columns as well.
Step 6 – Data Validation will be removed
– After completing all the steps mentioned above, data validation will be removed and you can now add any value in the Region column.
