up vote 1 down vote favorite
share [g+] share [fb]

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.

link|improve this question
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
feedback

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

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

3 Answers

up vote 1 down vote

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.

link|improve this answer
feedback
up vote 0 down vote

There is a shortcut, it's Alt + EL.

link|improve this answer
feedback
up vote -1 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard