how to restore disappeared drop list of data validation?

P

ping

the drop down list of data validation disappeared from one of the worksheet.
no more drop down list appear for new data validation.
it happens on one worksheet only. I suspect the worksheet is somehow
corrupt. it works fine on other tabs. how do I get the drop down list again?
 
B

Bob Phillips

If you are referring to the arrow icon, I don't think you can, you will need
to rebuild it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

ping said:
the drop down list of data validation disappeared from one of the worksheet.
no more drop down list appear for new data validation.
it happens on one worksheet only. I suspect the worksheet is somehow
corrupt. it works fine on other tabs. how do I get the drop down list
Click to expand...
again?
 
R

Ron de Bruin

Hi

Ctrl-A (two times to select all cells
Ctrl-C to copy
Insert Worksheet
Ctrl-v to paste in A1 of the new sheet

Have you used code to delete shapes ??
 
Top