Cell entry from list only - TechRepublic
Question
July 30, 2011 at 08:00 PM
radar1751

Cell entry from list only

by radar1751 . Updated 14 years, 11 months ago

I want users to enter information in a cell using a drop-down list and nothing else. If I lock the cell and protect the worksheet, it prevents them from using the drop-down list. How do I prevent them from entering any old data and force them to use only the drop-down list?

This discussion is locked

All Comments