Data validation

[Diddy]

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

 

[Luke M]

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

 

[Gord Dibben]

F5>Special>Data Validation>OK

Edit>Clear Contents.

If your text in the "non-data val cells in between" is derived from formulas
based upon the Data Val cells then that text will be removed also.

To retain that text you would have to copy/paste as values before re-setting
the Data Val cells to blank.


Gord Dibben MS Excel MVP

 

[Diddy]

Thank you Luke,

I took Protection off and it worked beautifully!