I am editing a spreadsheet and want to set multiple values of the same column to the same value.
Is there a way to easily do it?
The easiest way to do this is using ‘Batch Edit’ tool. You can find it in the Date | Batch Edit menu.
First, select rows where you want to change the values, then set ‘Rows’ field to ‘Selected’, and
enter the new value in the corresponding column.
Also look:
- Batch Edit wiki page