You can watch a video tutorial here.

An Excel file is called a workbook and it contains multiple worksheets. The number of worksheets in a workbook is limited only by the memory of your computer. Worksheets are also known as tabs because of how they are displayed in the workbook. You may want to delete a set of tabs from a workbook as they are no longer needed. There are 2 ways in which this can be done in Excel:

1. Use the context menu
2. Use the Home menu

Option 1 – Use the context menu

Step 1 – Select the tabs to be deleted

• Select the first tab to be deleted
• Hold down the Ctrl key and select all the other tabs that are to be deleted
• The selected tabs will have a white background against the name

Step 2 – Click on Delete

• Right-click to open the context menu
• Select Delete

Step 3 – Confirm the deletion

• Click Delete to confirm that the tabs are to be deleted

Step 4 – Check the result

• The tabs or sheets are deleted from the workbook

Note: It is not possible to delete all tabs or sheets from a workbook. At least one sheet should remain

Option 2 – Use the Home menu

Step 1 – Select the tabs to be deleted

• Select the first tab to be deleted
• Hold down the Ctrl key and select all the other tabs that are to be deleted
• The selected tabs will have a white background against the name

Step 2 – Choose the Delete Sheet option

• Go to Home > Cells
• Expand the Delete menu
• Select Delete Sheet

Step 3 – Confirm the deletion

• Click Delete to confirm that the tabs are to be deleted

Step 4 – Check the result

• The tabs or sheets are deleted from the workbook

Note: It is not possible to delete all tabs or sheets from a workbook. At least one sheet should remain