How to Delete a Sheet in Excel (5 Ways)

Deleting a sheet is necessary when you don’t need a sheet, or you might need to remove useless sheets. This tutorial will show you how to delete a sheet in Excel. Using these ways will help you to delete a sheet easily.

We are showing 5 ways to delete a sheet. You can choose any among them suited to your needs. But in our opinion, you must know every way to enrich your knowledge.


Download Practice Workbook


5 Ways to Delete a Sheet in Excel

Note: We did all of our processes by minimizing our window so it might look different. But you will find every option there. 

1. Using Delete from Cell Tab

The first method is basic delete using the Cell option from the HOME tab. This is our main data in sheet1. Copy this table and paste it on Sheet2.

Dataset for how to delete a sheet in excel

We are going to delete Sheet2.

sheet 2 for deleting a sheet

Step 1:  Go to the Cell option in the Home tab. You will find the Delete option.

Delete option from cell tab in excel

Step 2: Click the Delete option. You will find the Delete Sheet option.

Select delete option to delete sheet

Step3: Now, click the Delete Sheet option. It will show you a prompt.

delete prompt for deleting the sheet

Step 4: Click Delete. 

only sheet in the workbook after deleting

You can see here that Sheet2 is deleted. Only Sheet1 is left.

Read more: How to Delete Multiple Sheets in Excel

2. Using Worksheet Shortcut Menu

Now, this method is the most used. This seems pretty easy to almost all the users. We are also going to Delete Sheet2 using this.

Step 1: Right Click on the Sheet2. You will see a menu.

menu for how to delete a sheet in excel

Step 2: Click the Delete option. You will see the prompt to delete.

delete prompt for deleting the sheet

Step 3: Click Delete.  

only sheet in the workbook after deleting

Finally, only one sheet left.

3. Using Regular Keyboard Shortcut

ALT + H + D +S

Using the regular keyboard shortcut is also a way to delete a sheet. Though it is lengthy compared to other methods, it will also come in handy in different scenarios.

Step 1:  Select the Sheet2. Then press Alt + H + D + S.  You don’t have to press it all together. Press it one but one. You will see the option that you selected by pressing these.

delete sheet using keyboard shortcut

Step 2: After pressing those you will see the prompt. Click Delete to delete the Sheet2.

delete prompt after pressing shortcut

Your sheet will be deleted. You can only see sheet1.

only sheet in the workbook after deleting

4. Delete a Sheet Using Hybrid Keyboard Shortcut

Right-Click + D

Now, this is my personal favorite. You can use this to delete any sheet quickly.

Step 1: Select the Sheet2. Right-Click on the sheet. It will open the shortcut menu. But this time press D.

worksheet menu for deleting the cell

Step 2: It will show you the prompt. Click Delete.

delete prompt for deleting the sheet

Your Sheet will be deleted. Only one sheet will be left.

only sheet in the workbook after deleting

5. Using Legacy Keyboard Shortcut to Delete a Sheet

There were shortcuts in pre-Excel (2007) era. There is a sequence of commands which are also supported in newer versions of Excel.

ALT + E + L

Now, this method is not often used. But, we think you should also learn this. It will enhance your knowledge of Excel. You don’t have to press it all together. Press one by one.

Step 1: Select sheet2. Then press Alt + E + L.

delete sheet using legacy keyboard shortcut

Step 2: It will show a delete prompt. Click Delete.

delete prompt after using legacy keyboard shortcut

Sheet2 will be deleted. Only Sheet1 will be left.

only sheet in the workbook after deleting


Bonus: How to Delete Multiple Sheets at Once

Though our article is all about Delete a Sheet, it will be useful if you learn this also in the same way. This will be much easier if you learn any of those previous methods.

Step 1: First, create multiple sheets to delete. Then, select all those extra sheets using Shift or Ctrl. 

select multiple sheets to delete

Step 2: Now, your sheets are selected. Then, apply any of those previous methods shown earlier. Again, It will show a delete prompt. Click Delete.

delete prompt to delete sheets

Finally, you will see all those sheets are deleted.

only sheet in the workbook after deleting


💬 Things to Remember

These methods permanently Delete those sheets. If you are not sure whether you need them after or not, make a copy of those sheets.

If there is only one sheet in the workbook, you can’t delete this. However, you need at least more than one sheet to delete.


Conclusion

In the end, I hope these formulas on how to delete a sheet in Excel have enhanced your knowledge of Excel. We are giving you a practice workbook with multiple sheets, try to delete those sheets using those formulas. Give these a try. Also, be sure to check our website Exceldemy.com to know more about Excel’s problems and their solutions.


Related Articles

Shanto

Shanto

Hello! I am Shanto. An Excel & VBA Content Developer. My goal is to provide our readers with great tutorials on various Excel-related problems. I hope our easy but effective tutorials will enrich your knowledge. I have completed my BSc in Computer Science & Engineering from Daffodil International University. Working with data was always my passion. Love to work with data, analyze those, and find patterns. Also, love to research. Always look for challenges to keep me growing.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo