---
title: "Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode"
author: "Martin Hawksey"
date: 2019-10-03T17:21:49+00:00
canonical_url: https://pulse.appsscript.info/p/2019/10/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets-yagisanatode/
markdown_url: https://pulse.appsscript.info/p/2019/10/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets-yagisanatode.md
categories:
  - "Sheets"
  - "Solutions"
tags:
  - "yagisanatode.com"
featured_image: https://pulse.appsscript.info/files/2019/10/Google-Sheets-Percentage-Difference-and-formula-1.gif
description: "Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading Great..."
---

# Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode

![Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode](https://pulse.appsscript.info/files/2019/10/Google-Sheets-Percentage-Difference-and-formula-1.gif)

> [https://yagisanatode.com/2019/07/22/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets/](https://yagisanatode.com/2019/07/22/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets/)
> Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading

Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on [How to check if there is a Tick Box (Check Box) in a cell or range**](https://yagisanatode.com/2019/07/16/google-apps-script-how-to-check-if-there-is-a-tick-box-check-box-in-a-cell-or-range/)

Source: *[Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets – Yagisanatode*](https://yagisanatode.com/2019/07/22/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2019/10/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets-yagisanatode/](https://pulse.appsscript.info/p/2019/10/google-apps-script-create-a-select-all-checkbox-to-tick-checkboxes-in-any-desired-range-in-google-sheets-yagisanatode/)*