Every time I try to do this, I got stuck for a few minutes trying to remember from where to do it. For example i want to create a list of tasks and their corresponding statuses like (Not started, In progress, Completed, Accepted) etc. So this is how it is done.
One line solution
- Go to the data validation section. Choose type = List and then provide a list of values you want to appear in the drop down separated by comma.
No comments:
Post a Comment
If you like to say anything (good/bad), Please do not hesitate...