How to Delete Multiple Sheets in Google Sheets: A Step-by-Step Guide

Name: How to Delete Multiple Sheets on Google Sheets - Easy Guide 2026
Uploaded: 2026-03-16
Duration: 31 s
Description: Learn how to delete multiple sheets in Google Sheets, whether you delete sheets individually or automate with Apps Script. This practical guide covers manual deletion, batch methods, safety tips, and best practices for clean, organized workbooks.

Learn how to delete multiple sheets in Google Sheets, whether you delete sheets individually or automate with Apps Script. This practical guide covers manual deletion, batch methods, safety tips, and best practices for clean, organized workbooks.

How To Sheets Team

March 16, 2026·5 min read

Search-Google-Sheets What-Is-Google-Sheets Open-In-Google-Sheets

Delete Multiple Sheets - How To Sheets — Photo by Bich Tran via Pexels

Quick AnswerSteps

Deleting multiple sheets in Google Sheets can be done manually one by one, or you can automate the process with Apps Script for bulk cleanup. While native batch deletion isn’t always straightforward, this guide walks you through safe manual steps and efficient scripting options to keep your workbook tidy and fast.

Why Cleaning Your Workbook Matters

According to How To Sheets, organizing a Google Sheets workbook by removing unused or redundant sheets improves clarity, reduces confusion for collaborators, and can help with performance on larger files. A lean workbook loads faster in the browser and makes it easier to locate the data you actually need. The How To Sheets team found that users who routinely audit their sheets tend to avoid accidental data exposure and miscommunication in team projects. In practice, you’ll want to identify sheets that no longer serve a purpose, such as outdated templates, duplicate data views, or test sheets that were used during development. Before you delete anything, confirm you are removing the correct tabs and consider archiving a copy for safety.

In this context, the task of deleting multiple sheets in Google Sheets is less about a single button and more about a deliberate workflow that minimizes risk while keeping your workbook clean. You’ll learn both straightforward manual steps and a script-driven approach for bulk deletions. If you manage a lot of sheets across many workbooks, developing a repeatable process can save time and reduce errors over the long term.

Quick guide overview: manual vs automated

The fastest path for removing a few sheets is manual deletion, but as the number of sheets grows, automation becomes appealing. Manual deletion is simple: select a sheet, open the delete option, and confirm. However, Google Sheets does not always provide a built-in, single-click multi-sheet delete capability, which means bulk cleanup often requires a scripted solution or a sequence of careful manual actions. This section compares manual deletion and Apps Script options, so you can decide which approach fits your workflow. According to user feedback collected by How To Sheets, teams frequently combine both methods: delete a handful of sheets manually, then run a small script to remove a larger batch while preserving backups and version history.

Manual deletion: the everyday approach

Manual deletion in Google Sheets involves interacting with the sheet tab UI. Start by opening the workbook, then right-clicking the tab you want to remove and selecting Delete. If you hold Shift while selecting adjacent tabs, you may be able to delete a small range in one action, but this behavior isn’t guaranteed across all browser setups. In practice, many users delete sheets one by one to avoid mistakes. A quick tip is to rename candidate sheets to a recognizable prefix (e.g., OLD_) before removal, so you can quickly identify what’s being purged. Always confirm that the sheet you delete is truly surplus data and not a live data source used by formulas or charts.

Apps Script: delete multiple sheets efficiently

Apps Script offers a programmable route to bulk-delete, which is ideal when you have predictable sheet names or patterns. You can write a short script to delete sheets by name or by index, looping through a list of targets and removing them if they exist. This approach minimizes manual clicks and reduces the chance of deleting the wrong sheet. Before running any script, make sure you save a backup, enable the Apps Script editor from Extensions > Apps Script, and test with a dry run on a copy of your workbook. In the long run, script-based deletion scales much better for large workbooks or recurring maintenance.

JavaScript

function deleteSheetsByName(names) {
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  names.forEach(function(n) {
    var sh = ss.getSheetByName(n);
    if (sh) ss.deleteSheet(sh);
  });
}

This script accepts an array of sheet names and deletes each existing sheet. To use it, supply a precise list of the sheets you want to remove, then run the function from the Apps Script editor. If you don’t know all the exact names, you can build the list programmatically, or adapt the script to delete sheets by a naming convention (e.g., those starting with OLD_).

Safe backups and data integrity

Before you delete any sheet, create a backup copy of the workbook. Use File > Make a copy to preserve the current state, or export critical sheets as separate files (CSV or Excel) for archival purposes. Depending on your collaboration setup, enable version history so you can roll back unintended deletions. When working with shared files, communicate the plan with teammates to avoid confusion and ensure you don’t delete something someone else still needs. If you rely on formulas that reference deleted sheets, you’ll want to test all affected formulas after the removal to catch broken references early.

Best practices for bulk cleanup workflows

Plan first: list the sheets to delete and confirm they are not in use by charts, named ranges, or references in formulas.
Backup aggressively: keep a copy for safety and consider scheduled backups for large workbooks.
Test in a copy: perform all deletions on a duplicate copy before touching the live file.
Use Apps Script for bulk tasks: script-based deletion saves time and reduces errors when dealing with dozens of sheets.
Document changes: add a brief notes sheet or a log to indicate what was deleted and why.

Authority and references

For further guidance on Sheets workflows and data management best practices, see the following external resources. These sources provide structured guidance on spreadsheet management, scripting, and data integrity, which align with the practices described in this guide.

https://developers.google.com/apps-script/guides
https://support.google.com/docs/answer/60685
https://edu.google.com/

Next steps: verification and pitfalls to avoid

After completing deletions, re-check all formulas, charts, and pivot tables to verify they no longer reference removed sheets. If you encounter errors, use Version History to identify when changes occurred and revert selectively if needed. Keep a habit of saving backups after major cleanup, especially before publishing a workbook to stakeholders. With a clean slate, you’ll find it easier to maintain data integrity and ensure your team always works from the most accurate version of your workbook.

Tools & Materials

Computer or mobile device with internet access(Any device that can run Google Sheets; stay logged into your Google account)
Target Google Sheet(The workbook containing sheets you want to delete)
Backup copy(Create a copy of the workbook before deletion)
Apps Script editor (optional)(Extensions > Apps Script; needed for batch deletion via code)
List of sheet names to delete (optional but recommended)(Helps avoid deleting the wrong sheets during a script run)

Steps

Estimated time: 15-25 minutes

1
Decide deletion method
Assess whether you’ll delete sheets manually or via Apps Script. If you’re removing only a few sheets, manual steps are fine; for many sheets, scripting saves time and reduces risk. Always plan and back up first.
Tip: Create a backup copy of the workbook before making deletions.
2
Open the target Google Sheet
Navigate to the Google Sheet in your browser and locate the sheet tabs along the bottom. Review the list of sheets to identify those that are safe to delete and which ones should be archived.
Tip: Annotate sheets to delete with a temporary marker (e.g., prefix OLD_) to prevent mistakes.
3
Delete a single sheet manually
Right-click the tab of the sheet you want to remove and select Delete. Confirm the action if prompted. This action is permanent in the active workbook, so be sure before you proceed.
Tip: If you’re unsure, use Version History to compare the before/after state.
4
Attempt multi-sheet deletion (if supported)
Some sessions allow selecting multiple adjacent sheets with Shift-click and then deleting. If your environment doesn’t support this, skip to Apps Script for bulk removal.
Tip: Test on a copy first to ensure multi-select behaves as expected in your browser.
5
Apply Apps Script for bulk deletion
Open Extensions > Apps Script, paste a script that deletes sheets by name or by a pattern, save, and run. Start with a dry run on a copy to confirm only the intended sheets are removed.
Tip: Use a test list of names to validate behavior before a full run.
6
Verify and restore if needed
Check charts, formulas, and data links for references to deleted sheets. If something is amiss, revert to a previous version or restore from the backup you created.
Tip: Keep a short change log to track which sheets were removed.

Pro Tip: Back up before any bulk deletion to prevent accidental data loss.

Warning: Deleting a sheet is not easily undone; rely on version history and backups.

Note: If your workbook is linked to other sheets or dashboards, ensure those references are updated after deletion.

Pro Tip: Label sheets clearly (e.g., OLD_ or ARCHIVE_) before removing them to avoid confusion.

FAQ

Can I delete multiple sheets at once in Google Sheets?

Native multi-sheet deletion isn’t reliably supported in the Google Sheets UI. You typically delete sheets one by one, or use Apps Script to batch delete. For bulk needs, scripting is the recommended approach.

How should I back up before deleting sheets?

Create a copy of the workbook via File > Make a copy and consider exporting key sheets as separate files. This gives you a restore point if you need to revert.

Can I restore a deleted sheet later?

Yes. Use Version History to restore previous states or recover from a backup copy. If you delete something by mistake, revert to a version prior to the deletion.

Is there a time limit or limit to deletions per day?

There isn’t a documented daily limit on deletions, but large deletions can affect performance and cause more risk in shared workbooks. Plan bulk actions during low-traffic periods.

What if I delete a template or essential sheet?

If you delete an essential sheet by mistake, immediately check Version History or restore from backup. Going forward, prefix templates with a clear marker and keep a dedicated archive sheet.