Catalog

How to Delete Multiple Sheets in Excel

July 31, 2023 1.6K views

If you are a frequent Excel user, you might have found yourself in a situation where you must delete multiple sheets in one go. This task can be tedious and time-consuming, especially if you have many sheets. Luckily, there are several efficient ways to delete multiple sheets in Excel. 

How to Delete Multiple Sheets in Excel Online

If you are using Excel online, you can delete multiple sheets by following these simple steps:

  1. Open the Excel file and open the sheet.

  2. Select "Delete" from the drop-down menu.

  3. Repeat steps 2 and 3 for all the sheets you want to delete.

This method is straightforward and works well for small Excel files.

select  'delete'

How to Delete Multiple Sheets in Excel Using VBA

If you are working with large Excel files and need to delete multiple sheets, using VBA can save you a lot of time. Here is how you can delete multiple sheets in Excel using VBA:

  1. Press "Alt + F11" to open the Visual Basic Editor.

  2. In the editor, click "Insert" and select "Module" from the drop-down menu.

  3. Use the following code:

Sub DeleteSheets()

Dim i As Integer

For i = ActiveWorkbook.Sheets.Count To 1 Step -1

If ActiveWorkbook.Sheets(i).Name = "Sheet1" _

Or ActiveWorkbook.Sheets(i).Name = "Sheet2" _

Or ActiveWorkbook.Sheets(i).Name = "Sheet3" Then

Application.DisplayAlerts = False

ActiveWorkbook.Sheets(i).Delete

Application.DisplayAlerts = True

End If

Next i

End Sub

  1. Modify the code to include the names of the sheets that you want to delete.

  2. Press F5 to run the code.

The VBA code deletes all the sheets that match the names you specified. You can modify the code to include more sheets or change the criteria for deleting sheets.

Trustpilot

stars

4.8
WPS Office- Free All-in-One Office Suite
  • Use Word, Excel, and PPT for FREE, No Ads.

  • Edit PDF files with the powerful PDF toolkit.

  • Microsoft-like interface. Easy to learn. 100% Compatibility.

  • Boost your productivity with WPS's abundant free Word, Excel, PPT, and CV templates.

5,820,008 User

avator

Algirdas Jasaitis

How to Delete Multiple Sheets in Excel 2007, 2010, and 2013

If you use Excel 2007, 2010, or 2013, you can delete multiple sheets by following these steps:

  1. Open the Excel file.

  2. Press and hold the "Ctrl" key and click on the sheet tabs you want to delete.

  3. Right-click on one of the selected sheet tabs and choose "Delete" from the drop-down menu.

  4. Click "OK" to confirm the deletion of the selected sheets.

This method is effective for small to medium-sized Excel files. The steps are simple and anyone can easily delete multiple sheets in Excel.

Why Choose WPS Office to Delete Multiple Sheets in Excel

Deleting multiple sheets in Excel can be a bit overwhelming, especially if you have a lot of sheets. But don't worry; there are several efficient ways to delete sheets in Excel, including online, with VBA, and in different Excel versions.

If you're looking for comprehensive spreadsheet software that can handle all your Excel needs, we highly recommend trying WPS Spreadsheet. With its user-friendly interface, advanced features, and compatibility with Excel files, it's sure to simplify your Excel tasks! So go ahead and check it out! Download the WPS Office for a productive and efficient workflow.

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.