Susan Harkins shows you a quick method for removing validation rules for multiple ranges in Excel, at the same time.

Learn to create efficient, interconnected Excel drop-down lists using range functions and data validation techniques. Multi-level drop-down ...

Use cell navigation techniques, such as hyperlinks or the INDIRECT function, to enable quick access to specific cells in the source worksheets for further investigation.

Launch Excel and create a new workbook. Select a cell to be used for entering data. Click the "Data" tab. Select "Data Validation" from the ribbon's "Data Tools" section.

Learn how to use a data validation control to allow users to select when to run multiple VBA procedures in Microsoft Excel.