Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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 Mar 12 '11 at 13:14

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

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

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
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

Your Answer


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