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.
We are going to delete Sheet2.
Step 1: Go to the Cell option in the Home tab. You will find the Delete option.
Step 2: Click the Delete option. You will find the Delete Sheet option.
Step3: Now, click the Delete Sheet option. It will show you a prompt.
Step 4: Click Delete.
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.
Step 2: Click the Delete option. You will see the prompt to delete.
Step 3: Click Delete.
Finally, only one sheet left.
3. Using Regular Keyboard Shortcut
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.
Step 2: After pressing those you will see the prompt. Click Delete to delete the Sheet2.
Your sheet will be deleted. You can only see sheet1.
4. Delete a Sheet Using Hybrid Keyboard Shortcut
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.
Step 2: It will show you the prompt. Click Delete.
Your Sheet will be deleted. Only one sheet will be left.
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.
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.
Step 2: It will show a delete prompt. Click Delete.
Sheet2 will be deleted. Only Sheet1 will be left.
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.
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.
Finally, you will see all those sheets are deleted.
💬 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.
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.