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!







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.

  1. 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)

    How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Right-Click Method, Step 1

  2. If there is a dialog box that shows up, choose Delete again

    How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Right-Click Method, Step 2

  3. Done!

    How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Right-Click Method, Step 3




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.

  1. Activate the sheet you want to delete by clicking on its tab if you haven’t activated it yet
  2. Go to the Home tab in your ribbon, click the Delete dropdown button there, and choose Delete Sheet

    How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Delete Button Method, Step 2

  3. If there is a dialog box that shows up, choose Delete

    How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Delete Button Method, Step 3

  4. Done!

    How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Delete Button Method, Step 4




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.

How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Result Example of Selecting Adjacent Sheet Tabs

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.

How to Delete a Sheet/Multiple Sheets in Excel - Screenshot of the Result Example of Selecting Non-Adjacent Sheet Tabls

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:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert