How to Delete Multiple Tabs in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on April 14, 2023

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


DeleteMultipleTabs delete multiple


Delete Multiple Adjacent Tabs

  1. 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.


DeleteMultipleTabs group


  1. Right-click on one of the tabs and click Delete.


DeleteMultipleTabs intro


In the Ribbon, go to Home > Cells > Delete Sheet.


DeleteMultipleTabs ribbon delete sheet


  1. A warning box appears to confirm you want to delete the sheet(s). Click OK.


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 need.


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

  1. 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.
  2. Once you have selected the tabs of the sheets you wish to delete, right-click on one of the selected tabs and click Delete.
  3. A warning appears from Google. Click OK to delete the sheet(s).


DeleteMultipleTabs gs warning


Also see: How to Add Multiple Worksheets, How to Delete Unwanted or Blank Pages, and How to Recover a Deleted Sheet.

AI Formula Generator

Try for Free

See all How-To Articles