Pages

Excel | How to create a drop down list on a cell

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.
Well, for me one line solution will do. So I am skipping the multiple lines solution. May be you could figure it out yourself.

No comments:

Post a Comment

If you like to say anything (good/bad), Please do not hesitate...