How To Uncheck All Checkboxes On Two Separate Rows In Google Sheets Update

To uncheck all checkboxes on two separate rows in Google Sheets, you can follow these steps:

1. Select the first row containing the checkboxes that you want to uncheck. You can click on the row number on the left-hand side of the sheet to select the entire row.

2. Right-click on the selected row and choose “Clear contents” from the context menu. This will remove the checkmarks from all the checkboxes in the row.

3. Repeat the same process for the second row containing the checkboxes that you want to uncheck.

Alternatively, you can use a script to uncheck all checkboxes in specific rows. Here is an example script that you can use:

1. Open your Google Sheets document and click on “Tools” from the menu bar.

2. Select “Script editor” from the drop-down menu. This will open the Google Apps Script editor.

3. Paste the following code into the script editor:

javascript
function uncheckCheckboxes() {
  var sheet = SpreadsheetApp.getActive().getActiveSheet();
  var row1 = sheet.getRange("A1:D1"); // Replace A1:D1 with the range of your first row containing checkboxes
  var row2 = sheet.getRange("A2:D2"); // Replace A2:D2 with the range of your second row containing checkboxes
  row1.getValues().forEach(function(row) {
    row.forEach(function(cell, index) {
      if (cell === true) {
        row1.getCell(1, index + 1).setValue(false);
      }
    });
  });
  row2.getValues().forEach(function(row) {
    row.forEach(function(cell, index) {
      if (cell === true) {
        row2.getCell(1, index + 1).setValue(false);
      }
    });
  });
}

1. Replace the ranges in the code with the ranges of your rows containing checkboxes.

2. Save the script by clicking on “File” and then “Save”.

3. Click on the “Run” button in the script editor to run the script. This will uncheck all checkboxes in the specified rows.

Note that you may need to authorize the script to access your Google Sheets document before you can run it.