Opening sheets for different purposes within an Excel document is an excellent feature. However, sometimes you may accidentally open multiple unnecessary sheets, which can cause redundancy, especially if you don’t know how to delete multiple sheets in Excel at once.
In this tutorial, we will learn how to delete a single sheet and then to delete multiple sheets simultaneously. This way, you can clean your document from unnecessary sheets with a single click!
Table of Contents
Delete a Single Sheet
To delete a single sheet, right-click on the name of the sheet you want to delete, and then click on Delete.
This will successfully delete a single sheet:
Delete Multiple Sheets
If you have more than one sheet you want to delete, you first need to select all sheets you want to delete.
- If the multiple sheets you want to delete are consecutive, first click on the name of the first (leftmost) sheet. Then, while pressing Shift on your keyboard, click on the last (rightmost) sheet you want to delete. This will select all sheets in between.
- If the multiple sheets you want to delete aren’t consecutive, click on the sheets individually while pressing Ctrl on your keyboard.
After selecting the sheets you want to delete, right-click on a sheet name within your selection, and click on Delete.
This way, multiple sheets are deleted in an instant!
In this tutorial, we learned how to delete a single sheet and multiple sheets at the same time.
Related Tutorials: Delete a Comment in Excel Sum Across Multiple Sheets in Excel