nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

ChernoffTurtle7

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

2026-09-21_9-41-05.png

Accepted answers

Add "Yes" to clipboard
Select the column and rows
Paste the values

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

All comments

Add "Yes" to clipboard
Select the column and rows
Paste the values

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

ChernoffTurtle7

I like both. Thanks!

Quick Links