See all How-To Articles

How to Delete Multiple Tabs in Excel & Google Sheets

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

 

DeleteMultipleTabs delete multiple

 

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.

 

DeleteMultipleTabs group

 

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

 

DeleteMultipleTabs intro

 

OR

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

 

DeleteMultipleTabs ribbon delete sheet

 

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

 

DeleteMultipleTabs warning

 

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.

 

DeleteMultipleTabs group non adjacent

 

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.

 

DeleteMultipleTabs gs warning