Buy Now
Deleting-Multiple-Sheets

How to Delete Sheets in Excel: Deleting Multiple Sheets at Once

Jun 13, 2022

While you work within an Excel workbook, you might unintentionally add too many worksheets to your workbook.

While having multiple worksheets is handy in many situations, having too many can frustrating, especially if you don't know how to delete multiple worksheets.

In fact, not many Excel users know how to delete worksheets more than one at a time. Until now!

This article will show you how to delete multiple sheets in Excel, so you don't find yourself spending far too long clicking "delete sheet" each time.

Deleting a Single Sheet in Excel Workbook

 

Before we look at how to delete multiple sheets, let's quickly look at deleting worksheets one at a time. To do this, simply select your active worksheet, right-click, and select delete sheet.

You will know you have selected your active sheet as the color of the tab will change and differ from your other tabs. Once you are happy you have chosen the right tab, you can select the delete option and hit the delete button.

Delete multiple sheets in Excel

Now we have quickly covered how to delete a single sheet in Excel, let's look at how to delete multiple sheets.

To do this, you need to select multiple sheets, right-click on any of the selected sheets in excel and press delete. But how do you select multiple sheets in the first place?

Start by clicking on the first sheet tab you definitely want to delete. from here, press the shift key, and click the last tab you want to delete. You will notice that if you use this keyboard shortcut you will have highlighted all the tabs in between the two tabs you have clicked, making it quick and easy to delete multiple sheets.

Color multiple Excel worksheet tabs | Excel, VBA

However, if the sheets you want to delete are not in an easy to select order, you should use a different technique.

This time, click on the first sheet tab you want to delete as before. However, this time in the deleting process, we are going to do something a little different. To easily delete sheets that are not next to each other in your workbook, hold down the CTRL key and click on all the sheet names you want to delete. Your selected worksheet tabs will now be highlighted, and you can simply delete them by following the same process as before.

Deleting worksheets in excel is an excellent skill to learn, so you can delete a worksheet when needed and keep your workbook tidy.

With any of these options, you will see a warning dialogue box appear before you click delete, so you can double-check you have chosen the right sheet name in the worksheet application.

Be sure to save your excel worksheet before you press delete, just in case you make any mistakes!

Related Articles

How to Insert Line of Best Fit in Google Spreadsheets

Microsoft Excel is Waiting for Another Application to complete an OLE Action - What Does This Mean?

What is Apple Numbers For Mac: Everything You Need to Know

Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras sed sapien quam. Sed dapibus est id enim facilisis, at posuere turpis adipiscing. Quisque sit amet dui dui.

Call To Action

Stay connected with news and updates!

Join our mailing list to receive the latest news and updates from our team.
Don't worry, your information will not be shared.

We hate SPAM. We will never sell your information, for any reason.