---
title: "Clearing cells in multiple Google Sheets using Google Apps Script"
author: "Martin Hawksey"
date: 2022-08-10T19:26:13+00:00
modified: 2022-08-10T19:27:07+00:00
canonical_url: https://pulse.appsscript.info/p/2022/08/clearing-cells-in-multiple-google-sheets-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/08/clearing-cells-in-multiple-google-sheets-using-google-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Snippet"
  - "V8"
tags:
  - "tanaikech.github.io"
featured_image: https://pulse.appsscript.info/files/2022/08/Screenshot-2022-08-10-19.57.55.png
description: "Handy little code pattern for clearing ranges across multiple tabs in Google Sheets. Snippets are provided for both SpreadsheetApp and the advanced Sheets service."
---

# Clearing cells in multiple Google Sheets using Google Apps Script

![Clearing cells in multiple Google Sheets using Google Apps Script](https://pulse.appsscript.info/files/2022/08/Screenshot-2022-08-10-19.57.55.png)

> This is a sample script for clearing the discrete cell values on multiple sheets using Google Apps Script.

Handy little code pattern for clearing ranges across multiple tabs in Google Sheets. Snippets are provided for both SpreadsheetApp and the advanced Sheets service.

Source: [*Clearing Discrete Cell Values on Multiple Sheets using Google Apps Script***](https://tanaikech.github.io/2022/08/08/clearing-discrete-cell-values-on-multiple-sheets-using-google-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/08/clearing-cells-in-multiple-google-sheets-using-google-apps-script/](https://pulse.appsscript.info/p/2022/08/clearing-cells-in-multiple-google-sheets-using-google-apps-script/)*