Drop Down in Excel 2003

D

Don

I have copied and pasted data from one workbook to another. The original one
had dropdown menus and the dropdown has come with the data that I wanted.
(The new dropdown has no options). Normally I wouldn't care but I need to
protect the sheet and I cannot protect the cells where there is a dropdown
for some reason.

Could anyone offer any solutions please

Thanks
 
D

Duke Carey

Select the cells that have drop downs, then go to Data->Validation and press
the Clear all button in the dialog box
 
Top