Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I know the shortcut to add a new worksheet (SHIFT+F11).

But please tell me the shortcut to delete a worksheet. I spend a huge amount of time on selecting worksheet through mouse and deleting them.

Please provide a keyboard shortcut.

share|improve this question

migrated from stackoverflow.com Mar 12 '11 at 13:14

This question came from our site for professional and enthusiast programmers.

1  
Right click the sheet name > Press 'D'. In this way, you can keep your mouse cursor not moving if you wish to delete multiple consecutive sheets. –  wilson Mar 16 '11 at 4:16

3 Answers 3

You can place a macro in your Personals.xls file. This is with warnings off so it won't bother you with verifying, but makes it more dangerous.

Sub Delete_Sheets_with_keys()
Application.DisplayAlerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
End Sub

Tools >Macro >Macros and highlight the macro.

Click Options and assign a shortcut combination.

share|improve this answer

The keyboard shortcut from Excel 2003 is: Alt + E,L. The newer versions (at least 2007 & 2010) still honor this shortcut, however there is now another way to accomplish this: Alt + H, D, S.

share|improve this answer

According to this, Excel does not provide a shortcut to delete a worksheet.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.