Discussion Locked

How do I create a Yes/No Drop down list

0 helpful

3 replies

by hattrick1 Dec 27, 2005 last reply Dec 28, 2005 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

In MS EXCEL, How do you create a simple 2 choice drag down list (Yes / No or Y/N)? Any help would be appreciated?

3 replies

Click the "data" menu, "validation", setting allow "list" and in the source box put Yes,NO

Poster rated this answer.

This question was closed by the author

This discussion is closed to new replies.