In this tutorial, misnia.com will share about How To Delete a Sheet In Excel Quickly and easily using 2 ways. In the following demonstration, we are using Microsoft Office Excel 2019 from Microsoft Corporation.
When you start Microsoft Excel, you are given a workbook. This Excel workbook can consist of many worksheets or sheets. By default, Microsoft Excel 2016 and later versions display one worksheet or sheet, while Microsoft Excel 2013 or earlier versions display three worksheets or sheets.
However, if one or three Excel worksheets or sheets displayed in the workbook are still lacking, you can add a new worksheet by clicking the New sheet button with the plus (+) icon to the right of the sheet name or by displaying multiple worksheets. or Excel sheets at once via the Excel Options settings.
If you are working with a lot of different but related data, of course you will need a lot of Excel worksheets. For example, suppose you are handling data for a number of projects. You can separate data based on projects handled in different Excel worksheets. This does not include worksheets or Excel sheets to accommodate temporary data that needs to be analyzed first.
In time, when the project has been completed or when you no longer need a worksheet or sheet containing temporary data, you need to delete it so that it is neat and not confusing. Deleting an Excel worksheet is not difficult. You can delete one or more Excel worksheets or sheets at once quite easily.
2 Way How To Delete a Sheet In Excel Quickly
The following is a way to delete one or more Excel worksheets at once through shortcut menus and buttons on the ribbon.
The First Way Through the shortcut menu.
To delete a single Excel worksheet or sheets, for example Sheet2 via shortcut menus, right-click on Sheet2's name (1) to activate and simultaneously display the shortcut menu and then select Delete (2).
To delete multiple Excel worksheets or sheets at once, such as Sheet2, Sheet3, Sheet4, Sheet5 and Sheet6, you need to first select all of them. Use the Shift or control key on your keyboard to select multiple worksheets in succession or use the Ctrl keyboard key to select multiple worksheets randomly.
To select Sheet2, Sheet3, Sheet4, Sheet5 and Sheet6, click Sheet2, press and hold the Shift or control key and then click Sheet6. Now, Sheet2, Sheet3, Sheet4, Sheet5 and Sheet6 are selected.
To delete, right-click the mouse on one of the sheet names, for example Sheet6(1) which is selected to display the shortcut menu and then select Delete(2).
In the Microsoft Excel confirmation dialog box that appears, click the Delete button (1) to confirm the deletion of the Excel worksheet or click the Cancel button (2) to cancel the deletion.
The second way is through the Delete button on the ribbon.
To delete one or more Excel worksheets or sheets at once via the Delete button on the ribbon, you need to first select all of them. To select one or more Excel worksheets at once, the steps are the same as in the first method.
When one or more Excel worksheets or sheets that you want to delete are selected, make sure you are on the Home tab, in the Cells group, click the Delete button (1) and from the drop-down menu that appears, click Delete Sheet (2).
Just like in the first method, in the confirmation dialog box that appears, click the Delete button to confirm the deletion of the Excel worksheet or click the Cancel button to cancel the deletion.
Those are a few simple tricks in Microsoft Excel about How To Delete a Sheet In Excel easily and quickly. A very easy tutorial for you new Microsoft Excel users. See the video tutorial on the Youtube link or you can open it directly in the video below.