Adding a Yes/No selection option to cells.

[cheiss8078]

I want to set up a cell so that when the cursor is on the cell a drop down option appears allowing the selection of a yes or no to be shown in the cell.

What's this called and how do I set it up?

Thanks,

cheiss8078

[martindwilson]

data /validation allow list in the list box type yes,no

[benishiryo]

hi cheiss8078. that would be a Data Validation. select the cells you want the dropdown applied to (say B1:B5). go to Data -> Data Validation -> Allow: List -> Source:
Yes,No

you could also refer it to cell reference that contains the "Yes" & "No" like:
G1:G2

[cheiss8078]

hi cheiss8078. that would be a Data Validation. select the cells you want the dropdown applied to (say B1:B5). go to Data -> Data Validation -> Allow: List -> Source:
Yes,No

you could also refer it to cell reference that contains the "Yes" & "No" like:
G1:G2

Very helpful...thanks for helping me learn something new.

Happy New Year!

cheiss8078