How to delete a sheet in Excel [Simplified steps]

Deleting Sheets In Excel

If you have added extra sheets by mistake or any other reason then do not worry because it is very easy to remove or delete a sheet in excel.

Locating current sheet

If you want to know the name of the current sheet you are working on in Excel, then simple run your eyes down at the status bar above which the sheet names are displayed.

You can see the sheet names as ‘Sheet1’, ‘Sheet2’ or ‘Sheet3’ depending upon the number of sheets you have created. Here is an illustration-

Sheet Name Display delete a sheet in Microsoft Excel
Sheet Name Display

Methods to delete a sheet in Excel

There are two methods to delete a sheet. Read the simplified steps to delete a sheet by two methods in excel below-

Method 1

  1. Right-click the sheet name you want to delete. For example- Right-click Sheet1.
  2. Select Delete. The sheet will be successfully deleted.
Sheet options at right-click delete a sheet in Excel
Sheet Options

Method 2

  1. Select and stay in the sheet you want to be deleted.
  2. Go to the Home tab above.
  3. Under the Cells section select the pull-down button under ‘Delete’.
  4. Select Delete Sheet. Your sheet will be successfully deleted.
Delete Sheet Options in Home Tab delete a sheet in Excel
Delete Sheet Options in Home Tab

Conclusion

The options are the same if you want to create or rename a sheet. You can also double-click a sheet name to be able to rename your sheet. If you have any doubts, comment your thoughts below and we’d be happy to help you out.