How to Delete Multiple Tabs in Excel & Google Sheets

This tutorial demonstrates how to delete multiple tabs in Excel and Google Sheets.

 

 

Delete Multiple Adjacent Tabs

Click on the tab of the first worksheet you wish to delete, and then holding down the SHIFT key, click on the tab of the last worksheet you wish to delete.

 

 

This puts your worksheets into group mode. Right-click on one of the tabs and select Delete.

 

 

OR

In the Ribbon, select Home > Cells > Delete Sheet.

 

 

A warning box will pop up. Click OK to delete the sheets.

 

 

Delete Non-Adjacent Tabs

To select non-adjacent sheets, click on the tab of the first sheet, and then, holding down the CTRL key, click on each additional sheet tab you require.

 

 

You can then delete the worksheets in the same way as you do for the adjacent sheet tabs.

Delete Multiple Tabs in Google Sheets

You can select adjacent and non-adjacent sheet tabs in Google Sheets in the same way you do in Excel, using either the SHIFT or CTRL keys on the keyboard.

Once you have selected the tabs of the sheets you wish to delete, right-click on one of the selected tabs and select Delete.

A warning will appear from Google. Click OK to delete the sheets.