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
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
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
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:
Right click on any one of the selected sheets and select Delete from the menu
A popup will appear to let you know how many sheets you’re deleting and ask if you wish to continue. Click on OK
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.