on April 29, 2011, 3:31 AM PDT Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time. Validation is a powerful feature that lets you control the data users can enter into an Excel sheet. Chances are that once you’ve put these rules into place, you’ll not want to remove it, but if you do, you might go about it the same way you set them:
That’s the mouse way; now, let’s work through another method:
Now, I admit that I don’t find this second method any easier than the first. In fact, I find it a bit cumbersome. However, I watched someone use it a few days ago and she was flying—so your mileage may vary! If you’re working with multiple ranges, you can select them all and remove all of the validation rules at once. Here’s a quick example using the sheet shown below. Ranges DateWorked (A2:A8) and Lunch (D2:D8) both have simple, but different, validation rules applied (the rule itself isn’t important.) If you select both ranges, Excel won’t let you work with the validation rules because they’re different, but it will let you delete the validation rules. Let’s select the ranges and see what happens:
Using the Name Box control to select non-contiguous ranges is a neat tip in an of itself!
In this post, you’ll learn how to delete or remove the Data Validation in Excel worksheets. It helps you in removing the applied validations in the cells in the worksheets. How to Remove Data Validation from Microsoft Excel ?To remove the data validation applied to the cells, follow the below steps:
How to Remove specific data validation rule in Excel?
How to Remove the Data Validation using Paste special in Excel?Paste Special feature paste the specific elements of copied cells. By this, it can remove data validation rules in a worksheet.
And Now the Data validations applied to the cells will be removed. |