Tip of the Day | Monday 14 September 2026

This tool removes all data validation settings from the selected cells in your worksheet(s).

If you have multiple worksheets selected (grouped), this tool removes the data validation from the same cell range on each sheet.
For example, if you select range B2:B10 and have 50 sheets grouped, the validation will be removed from B2:B10 on all 50 sheets.

Data validation is used to control what users can enter in a cell, such as limiting inputs to whole numbers, creating dropdown lists, or displaying input messages and error alerts.
This tool helps you quickly remove those restrictions while keeping the existing cell values, formulas, and formatting unchanged.

It's useful when you want to:

• Clear dropdown lists from copied or imported cells
• Remove input restrictions
• Eliminate error messages or custom prompts
• Reset cells before applying new validation settings

It works the same as Excel's Data > Data Tools > Data Validation > Settings > Clear All command.
The advantage of having this in ASAP Utilities is that it alsop works across multiple worksheets, and you can assign a shortcut to it via 'My Tools & Shortcut Keys' for accessibility and even faster access.

Starting this tool