Data Validation, Drop Down List Reset Values

Question

I have a spreadsheet that is a checklist of Software Validation Tests (Ironic I know).  In each row, the user is only allowed to select a "√", "x", "N/A" or " " from the drop down list to indicate the results of a particular test.  I'm looking for a method of resetting all the selections back to " " to reset the checklist.  I will have hundreds of cells that will need to be reset back to " ", so doing this one at a time will be unwieldy.  Any suggestions?

Thanks in advance

Answer 1

Hi unHappyJack

Will these entered symbols all be in the same column or row or are they spread all over the worksheet?