Hit Ctrl+G to bring up the Go-to dialogue. Click special, then click "data
validation - all". Hit delete to clear cells.

--
Best Regards,

Luke M
"Diddy" wrote in message
...
Hi,

I'm reusing a worksheet with a mixture of data validation and data entry
cells. The data validation is based on a list and the first cell in the
list
is blank.

Because the worksheet has been filled in I would like to re-set all data
without removing the text in the non-data val cells in between.

Is there any quick way to do this?

Cheers
Diddy