drop down lists
 

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??

drop down lists
 

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


"sarah - woolbro" wrote:

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??