How to Delete a Sheet/Multiple Sheets in Excel
Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Delete a Sheet/Multiple Sheets in Excel
In this tutorial, you will learn how to delete a sheet or multiple sheets in excel completely.
When working in excel, we sometimes want to delete the worksheets we have as we don’t need their contents anymore. To do the deletion process, we should understand the methods to delete worksheets in excel properly.
Want to understand how to delete single or multiple sheets in excel at once? Read this tutorial until its last part!
Disclaimer: This post may contain affiliate links from which we earn commission from qualifying purchases/actions at no additional cost for you. Learn more
Want to work faster and easier in Excel? Install and use Excel add-ins! Read this article to know the best Excel add-ins to use according to us!
Table of Contents:
How to Delete a Sheet in Excel 1: Right-Click
There are two sheet deletion methods we are going to discuss in this tutorial. The first one is the method to delete a sheet in excel by using right-click.This method is quite simple to implement as you can see in its step-by-step explanation below.
-
Right-click the tab of the worksheet you want to delete/remove and choose Delete (you can see your worksheet tabs in the bottom-left part of your excel workbook)
-
If there is a dialog box that shows up, choose Delete again
-
Done!
How to Delete a Sheet in Excel 2: Delete Button
Another method you can use to delete a sheet in excel is by using the Delete button in your excel ribbon. This method is simple to implement too.- Activate the sheet you want to delete by clicking on its tab if you haven’t activated it yet
-
Go to the Home tab in your ribbon, click the Delete dropdown button there, and choose Delete Sheet
-
If there is a dialog box that shows up, choose Delete
-
Done!
How to Delete Multiple Sheets in Excel at Once
To delete multiple sheets in excel, you need to select the tabs of the sheets you want to delete first.If you want to select multiple adjacent sheet tabs, click the most left tab of the adjacent sheet tabs. Then, hold the Shift button and click the most right tab of the adjacent sheet tabs you want to select.
You should get something like this after doing that.
If you want to select multiple non-adjacent sheet tabs, hold the Ctrl button (Command button in Mac). Then, click each of the tabs you want to select.
You should be able to get something like this after doing that.
After selecting the tabs of the worksheets to delete, you can implement one of the two methods we have discussed previously. Right-click on the tabs and choose Delete or click the Delete Sheet button in the Home tab. If there is a dialog box that shows up, choose Delete.
Doing all that will make you delete multiple sheets at once!
Shortcut to Delete Sheets in Excel
Want to delete your sheets by using keyboard shortcuts?If you use your excel in Windows OS, then you are in luck! There are three shortcut alternatives you can use to delete your sheets in excel. All of them require you to select the tabs of the sheets you want to delete first.
Those three keyboard shortcuts are:
- Right-click on the sheet tabs and then press D
- Press Alt -> H -> D -> S sequentially (this is actually a shortcut to access the Delete Sheet button in your ribbon)
- Press Alt -> E -> L sequentially (this is a legacy shortcut in excel. That means excel has got a new shortcut for the function (see above) but it keeps this shortcut for a compatibility reason)
Pressing any of these shortcuts on your keyboard will make you delete the worksheets which tab you currently select!
If you use Mac, then you can only right-click your sheet tabs, press D, and then press Enter. That is because Excel hasn’t provided Mac with shortcuts to access its ribbon currently.
Exercise
After you have learned how to delete your sheets in excel completely, now let’s try to practice the lessons. Open a new excel file, add some worksheets, and try to delete those worksheets by practicing the steps from this tutorial. What is the result after you do that? Can you delete the worksheets?Additional Note
Be careful when you delete your worksheets! You seem to cannot retrieve the worksheets back in any way (even with the undo button). If there is any reference to the worksheets in your formulas, they will produce an error after you delete those sheets!Related tutorials you should learn:
