I did a quick search, but was unable to find anything regarding this specifically.
I have a drop-down menu with 10 options. I want people using this sheet to only be able to choose from those predetermined options. If I leave the cell unprotected, someone can type something other than those options in the cell, but it I protect the cell you can't even choose one of the the options.
Is there an easy way to protect the cell so that you can only choose from the options given?
I have a drop-down menu with 10 options. I want people using this sheet to only be able to choose from those predetermined options. If I leave the cell unprotected, someone can type something other than those options in the cell, but it I protect the cell you can't even choose one of the the options.
Is there an easy way to protect the cell so that you can only choose from the options given?