Delete an Excel worksheet

How to delete a single Excel worksheet using Excel, VBA and Shortcut methods

METHOD 1. Delete an Excel worksheet using the sheet option

EXCEL

Right-click on the worksheet > Delete

1. Right-click on the worksheet that you want to delete.
2. Click Delete.
Note: in this example we are deleting Sheet2.		 Right-click on a worksheet and select Delete - Excel

METHOD 2. Delete an Excel worksheet using the ribbon option

EXCEL

Select a worksheet > Home tab > Cells group > Delete > Delete Sheet

1. Select the worksheet that you want to delete.
Note: in this example we are deleting Sheet2.		 Select the worksheet that you want to delete - Excel

2. Select the Home tab. Select Home tab - Excel

3. Click Delete in the Cells group.
4. Click Delete Sheet.		 Click Delete and click Delete Sheet - Excel

METHOD 1. Delete an Excel worksheet using VBA with a Worksheets object

VBA

Sub Delete_Worksheet()
'delete a worksheet named Sheet2
Worksheets("Sheet2").Delete

End Sub

OBJECTS
Worksheets: The Worksheets object represents all of the worksheets in a workbook, excluding chart sheets.
PREREQUISITES
Worksheet Name: Have a worksheet named Sheet2.
Minimum Number of Worksheets: The workbook has at least two worksheets.

ADJUSTABLE PARAMETERS
Worksheet Selection: Select the worksheet that you want to delete by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.

METHOD 2. Delete an Excel worksheet using VBA with a Sheets object

VBA

Sub Delete_Worksheet()
'delete a worksheet named Sheet2
Sheets("Sheet2").Delete

End Sub

OBJECTS
Sheets: The Sheets object represents all of the sheets in a workbook, including worksheets and chart sheets.
PREREQUISITES
Worksheet Name: Have a worksheet named Sheet2.
Minimum Number of Worksheets: The workbook has at least two worksheets.

ADJUSTABLE PARAMETERS
Worksheet Selection: Select the worksheet that you want to delete by changing the Sheet2 worksheet name in the VBA code to any worksheet in the workbook.

METHOD 3. Delete an Excel worksheet using VBA using sheet reference

VBA

Sub Delete_Worksheet_Using_Sheet_Reference()
'delete a worksheet that's referenced as the second worksheet
Sheet2.Delete

End Sub

OBJECTS
Sheets: The Sheets object represents all of the sheets in a workbook, including worksheets and chart sheets.
PREREQUISITES
Minimum Number of Worksheets: The workbook has at least two worksheets.

ADJUSTABLE PARAMETERS
Sheet Reference Selection: Select the worksheet that you want to delete by changing the sheet reference, in the VBA code, to the sheet reference that refers to the worksheet that you want to delete.

Delete a worksheet using a Shortcut

SHORTCUT

WINDOWS SHORTCUT

Alt
H
>
D
>
S

NOTES
Select the worksheet you want to delete, then action the shortcut.

Explanation about how to delete a worksheet

EXPLANATION

EXPLANATION
This tutorial explains and provides step by step instructions on how to delete a single worksheet using Excel, VBA and Shortcut methods.

Excel Methods: Using Excel you can delete a worksheet with a ribbon or sheet option.

VBA Methods: Using VBA you can delete a worksheet referencing to a Worksheets or Sheets object.

Shortcut Method: Using a Shortcut you can delete a selected worksheet.