Data validation
 

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

Data validation
 

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

Data validation
 

F5SpecialData ValidationOK

EditClear 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


On Tue, 25 May 2010 06:05:01 -0700, Diddy
wrote:

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

Data validation
 

Thank you Luke,

I took Protection off and it worked beautifully!

"Luke M" wrote:

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


.