Drop Down in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Select the cells that have drop downs, then go to Data->Validation and press
the Clear all button in the dialog box
 
Back
Top