Open In App

How to Delete a Sheet in Microsoft Excel

Last Updated : 29 May, 2024
Comments
Improve
Suggest changes
Like Article
Like
Report

Ever tried to manage your sheets in MS Excel? Keeping your data and sheets managed is a good idea of making your sheets well organized sometimes you also need to edit, organize and delete your sheets. In the case you are managing your sheets in a proper manner then you will need to delete some sheets sometimes. So, this article will explore how we can delete the sheets in MS Excel for proper organization.

How-to-Delete-a-Sheet-in-Microsoft-Excel
How to Delete a Sheet in Microsoft Excel

How to Delete an Individual Sheet in Microsoft Excel

Step 1: Open MS Excel

To open MS Excel on your desktop, navigate the MS Excel icon and give it a click.

Screenshot11-ezgifcom-png-to-webp-converter
Click on the Microsoft Excel icon to open the app

Step 2: Right-click on the Sheet Tab at the bottom left corner

After opening MS Excel on your desktop locate the sheet you want to delete and perform a right-click on the sheet tab you want to delete to open a drop-down menu.

Screenshot5-ezgifcom-png-to-webp-converter
Perform a right-click on the sheet tab

Step 3: Select "Delete" Button

When you perform a right-click on the sheet then a menu will appear on the screen containing some options, simply select the "Delete" option from the menu.

Screenshot6-ezgifcom-png-to-webp-converter
Select the "Delete" button

How to Delete a Sheet in Microsoft Excel Using Home Tab

Step 1: Open MS Excel

To open MS Excel on your desktop, navigate the MS Excel icon and give it a click.

Screenshot11-ezgifcom-png-to-webp-converter
Click on the MS Excel icon to open the app

Step 2: Go to the Home Tab and Click on the "Delete" Button

Now if you want to use the Home tab for deleting a sheet from MS Excel then first you have to click on the Home tab to view all the operations that can be done in MS Excel, after finding the "Delete" button which will give you some options to perform.

Screenshot7-ezgifcom-png-to-webp-converter
From Home tab >> Click the "Delete" button

Step 3: Select "Delete Sheet"

After clicking on the Delete button a menu will appear containing some options, among all the options select the "Delete Sheet" button to delete the selected sheet.

Screenshot8-ezgifcom-png-to-webp-converter
Click on the "Delete Sheet" button

How to Delete Multiple Sheets in Microsoft Excel

Step 1: Open MS Excel

To open MS Excel on your desktop, navigate the MS Excel icon and give it a click.

Screenshot11-ezgifcom-png-to-webp-converter
Click on the MS Excel icon to open the app

Step 2: Select the Sheets and Right-click

To select the sheets in MS Excel just click on the first sheet to be deleted and then click the "Ctrl" key in the keyboard and click on the sheets which you want to delete. After selecting the sheets, you want to delete a right-click on the sheets to view a menu.

Screenshot9-ezgifcom-png-to-webp-converter
Select the Sheets

Step 3: Select Delete

From the menu appears after clicking on the selected sheets select the "Delete" button to delete the sheets.

Screenshot10-ezgifcom-png-to-webp-converter
Select the "Delete" button

Conclusion

Deleting a sheet in MS Excel is a good idea for managing your sheets and data in MS Excel. In the above article, we have explored about the ways to delete the sheet in MS Excel, and you can choose any of the ways to perform your task. All you have to do is open MS Excel on your desktop and right-click on the sheet you want to delete then select the "Delete" button to delete the sheet. To delete the multiple, repeat the same steps but select the sheets first to delete them.

Can a Deleted sheet be recovered?

Yes, if you have deleted any sheet by mistake and want to recover it immediately then you can use the "Ctrl + Z" keys to recover it.

Can I hide a sheet in MS Excel instead of Deleting?

Yes, you can hide a sheet in MS Excel by the following steps:

  1. Open MS Excel
  2. Perform a right-click on Sheet tab
  3. Select "Hide" button

Next Article
Article Tags :

Similar Reads