How to batch fill 'Yes' in the column for the selected multiple rows

[#1]

If not use formula, is there any simple way to batch fill 'Yes' in the <validation> column for the selected multiple rows?

[#2 · Accepted solution]

1. Add "Yes" to clipboard
2. Select the column and rows
3. Paste the values

You can also use Name Selection In Column... (Rows > Row Selection > Name Selection in Column...)

[#3]

I like both. Thanks!