drop down lists

[sarah - woolbro]

i followed steps & created drop down lists in cells by creating lists in same
worksheet. all was fine but then they all disappeared but the drop down arrow
is still there? do i have to keep the lists in the worksheet that i used to
create the drop downs??

 

[Dave Curtis]

Hi,

You certainly need to keep the list somewhere, though they can be on a
different sheet, if you used a defined name to reference them.

Dave