How To Delete Multiple Sheets In Google Sheets

In this tutorial, you will learn how to delete multiple sheets in Google Sheets.

Google Sheets have a tendency to get more and more complicated as time goes on, with different users adding new sheets that are used once or twice but not useful after that. At a certain point, the sheer number of extra sheets in a workbook can become overwhelming, and a little pruning is in order

In the past, deleting multiple sheets in Google Sheets has been a slow painful process of individually deleting each sheet one at a time, but fortunately Google Sheets now makes it quick and easy to delete multiple sheets at the same time, so before you start deleting sheets from your spreadsheet one at a time, read this quick tutorial to learn the more efficient method

Selecting Multiple Sheets

First, before you can delete multiple sheets, you have to select them

Here’s how:

Step 1

Select the first sheet you want to delete by clicking on the tab with the sheet’s name on it at the bottom of the screen. If you can’t see the sheet, use the right and left arrows to the right of the sheet tabs to navigate through the sheets

Step 2

To select adjacent sheets, hold down the shift key and then click on the last sheet you want to delete. All sheets between the two selected sheets will be selected. Selected sheets will be highlighted white instead of grey

Step 3

You can select non-adjacent sheets by holding down control instead of shift and individually clicking on each sheet you want to select

Deleting Selected Sheets

Once you have the sheets you want to delete selected, here’s how to delete them:

Step 1

Right click on any one of the selected sheets and select Delete from the menu

Step 2

A popup will appear to let you know how many sheets you’re deleting and ask if you wish to continue. Click on OK

Step 3

That’s it. The sheets will be deleted from your spreadsheet


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to delete multiple sheets in Google Sheets. Want more? Check out all the Google Sheets Tutorials.