How to Quickly Delete Multiple Sheets in Excel

This practical guide walks through how to quickly delete multiple sheets in Excel, explains the main requirements, and highlights common issues that may appear along the way.

1. How to delete multiple Excel sheets by Ctrl

To delete a sheet in Excel , just right-click on the sheet you want to delete and select Delete .

To delete multiple sheets at the same time , we press and hold the Ctrl key, then click the sheets you want to delete, right-click and choose Delete .

Alternatively, you can also right-click a sheet and select Select All Sheets to select all the sheets .

Hold down the Ctrl key and click on the sheets you don't want to delete , and then press Delete to delete the rest.

Instructions for deleting multiple Excel sheets with Macros code

Besides the traditional delete Excel sheet above, we can also use Macros to delete multiple sheets at once.

Step 1:

You do not want to separate the sheet names you want to delete from other sheets. Then press Alt + F11 to launch Microsoft Visual Basic for Applications. Then click Insert> Module .

Step 2:

Next you enter the code below into the interface.

Public Sub Test() Application.DisplayAlerts = False Dim Ws As Worksheet For Each Ws In Worksheets If Ws.Name <> "Test" Then Ws.Delete Next Ws Application.DisplayAlerts = True End Sub

Here Test is the sheet you want to keep in the Excel table.

Step 3:

Continue to click Run to run the code in Excel.

Resulting all sheets in the data file have been deleted, except for the Test sheet that we entered in the code.