If you would rather prefer to ditch the mouse and only use the keyboard, the above keyboard shortcut will delete the active sheet or the selected sheets. Personally, I find this a lot faster than just using the mouse to delete a worksheet (as I covered in the above section) Regular Keyboard Shortcut to Delete Sheet ALT + H + D + S To delete the selected worksheet or worksheets, right-click and then press the D key on your keyboard. I say two and a half because one of the shortcuts he uses the mouse as well as the keyboard (and is still a faster way to do it) Hybrid Keyboard Shortcut to Delete Sheet Right-Click + D There is not one but two-and-half keyboard shortcuts that you can use to delete worksheets in Excel. if you try and delete all the worksheets (or the only active sheet), you’ll see a prompt that will tell you that you’re not allowed to do this Keyboard Shortcuts to Delete the WorkSheets there always needs to be at least one sheet in the workbook. Remember that you cannot delete all the worksheets in a workbook in Excel. now I can right-click on any of the selected sheets tabs, and click on delete. Once I’m done selecting the desired sheets, I can leave the control key. You can also use the same technique to delete multiple sheets at once.įor example, if I want to delete Sheet2 and Sheet3 in one go, I can hold the control key and click on Sheet2 and Sheet3 one by one (while still holding the control key).īy holding the control key, Excel would allow me to select multiple sheets at one go. For example, if I’m currently on Sheet1 and I want to delete Shee3, then I can simply right-click on Sheet3 and delete it.
You can also use the above technique on sheets that are not even the active sheet. In the prompt that shows up, click on the Delete button.Right-click on the sheet that you want to delete.Suppose, you have a worksheet that has three sheets as shown below, and you want to delete Sheet1.
The easiest way to delete a worksheet in Excel is by using this simple two-click mouse technique.
0 kommentar(er)
