1. Home
  2. MS Office
  3. Delete worksheet in excel

How to Delete a Worksheet in Excel: 2 Simple Methods

Microsoft Excel is a highly efficient app that lets you perform both simple and complicated calculations. It is also good for storing data. Users can open multiple sheets at the same time in a file.

After your work is done, deleting unnecessary sheets is a wise decision. Here, you will learn how to delete a worksheet in Microsoft Excel

 

 

How to Delete a Worksheet in Excel

As you create sheets in Excel, the tabs at the bottom represent each worksheet. Now, we will discuss how to delete a worksheet using two different methods.

Method 1: Right-Click

Step 1: First of all, you need to select the worksheet you no longer need.

Step 2: Right-click on the worksheet tab and a context menu will open. From the context menu, choose the Delete option.

Step 3: A dialog box will appear to confirm whether you want to proceed with the deleting process. Click on Delete.

Method 2: Cells Commands

Step 1: Open the worksheet you need to delete.

Step 2: Select the Home tab and then, click on the Delete option located under the Cells commands section.

Step 3: Click on Delete Sheet.

Step 4: If you get a warning about deleting a sheet permanently, select Delete again.

How to Delete Multiple Worksheets in Excel

You might need to delete multiple sheets in an Excel workbook. Instead of doing it one by one, you can perform the delete action at the same time.

Step 1: For this, you have to select all the sheets you want to delete and use the Shift or Ctrl button to select multiple worksheet tabs at once.

Step 2: Right-click and choose Delete from the context menu. You may also use the Delete option located on your Home tab.

That’s it! Excel will delete all those worksheets that you have selected. 

Find and Delete Hidden Tabs

Sometimes, a workbook contains too many sheets that it becomes difficult to manage. In this situation, people often hide sheets that they do not need at the moment. If you want to permanently delete the hidden worksheets, you need to unhide them first and then, proceed to delete them through the methods.

Here is what you need to do to find hidden tabs and unhide them.

Step 1: Open an Excel worksheet and right-click on any currently visible worksheet tab.

Step 2: Click on Unhide

Step 3: The Unhide dialog box will appear with a list of hidden worksheets. Highlight the sheet you want to unhide.

Step 4: Click on OK.

Step 5: The hidden sheet will be visible now besides other sheet tabs.

Conclusion

Excel offers users the facility to work with multiple spreadsheets or worksheets at a time. Due to its ability to create unlimited rows and columns, it becomes easier for Excel users to work with a large amount of data.

Once the work is done, you might not want some sheets from an Excel file. In that case, you must know how to delete a worksheet in Excel.

By following the steps mentioned in this Excel tutorial, you can easily remove any unnecessary worksheets from a workbook. We also discussed ways to unhide any hidden worksheet that you might need to delete as well.