Yes / No Feature

[DCSwearingen]

I have a spreadsheet where I want to give the user the ability to pick
"Yes" or "No", but not be able to enter anything else. I need to
duplicate this for each row in the spreadsheet.

Is there an easy way to do this without creating multiple drop down
combo boxes each time a row is added?

 

[dominicb]

Good afternoon DCSwearingen

Try using the Data > Validation tool, set up the parameters, message
to give to the user etc and copy it down. Simple to use and made fo
situations such as this.

HTH

Dominic