Faster At Excel

  • Home
  • Book: Excel Shortcut Bible

  • Shortcuts
  • Blog
  • Archives
  • Links
  • My Account
  • Login
  • About
  • Contact

4 Shortcuts To Delete Excel Worksheets

June 7, 2016 by terp Leave a Comment

4 Easy Ways To Delete Excel Worksheets

Below are four different shortcuts to delete Excel worksheets.  The second one is the fastest, and hence my favorite.

(1) Right-clicking: RC-<Delete> while hovering over the tab.  You’ll see the following when right-clicking over the tab — just click on Delete:

excel-delete-worksheet

(2) Hybrid shortcut: RC-D (Right-Click, followed by typing ‘D’).  This does the same thing as RC-<Delete>, except you’re using the hot key instead of clicking.  The ‘D’ is underlined in Delete, which means you can just type ‘D’ instead of clicking on Delete.  I call this a “hybrid” shortcut since it combines mouse and keyboard into one shortcut.  This is the fastest (typing ‘D’ is faster than clicking on ‘Delete’).

(3) Alt sequence: Alt-H-D-S.  This is basically Home > Delete> Sheet (which is painfully slow), but using your keyboard instead of the mouse.  You’ll probably need your right hand to type the ‘H’, which is inconvenient if you’re used to having your right hand on the mouse (like me).

(4) “Legacy” Alt sequence: Alt-E-L.  This is an Alt sequence that you really can’t follow on the screen anymore (you won’t see any hot keys appear), since it’s a ghost-like or “zombie” carryover from Excel 2003 (those Alt sequences were preserved, even though the ribbon menu has changed).  Typing the ‘L’ in this shortcut requires your right hand.

So to recap, you can delete an Excel worksheet using any of the following shortcuts:

(1) RC-<Delete>

(2) RC-D (the fastest)

(3) Alt-H-D-S

(4) Alt-E-L

Enjoy!

Filed Under: Alt Shortcuts, Delete, Excel Shortcuts, Hybrid shortcuts, Keyboard Shortcuts, Mouse Shortcuts, Right Click Tagged With: Alt Shortcuts, Excel Keyboard Shortcuts, Excel Mouse Shortcuts, Excel Shortcuts

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Post Categories

Tags

Alt Shortcuts Books challenges Charts comments cut copy paste data Double Click Excel Formulas Excel Keyboards Excel Keyboard Shortcuts Excel macros Excel Mouse Shortcuts Excel Shortcuts Excel Speed Tricks F-Key Shortcuts Filter Find & Replace Font format Format Cells Format Painter Formatting freeze panes Hybrid Shortcuts Menu Key Open Paste Formats Paste Special Paste Values Products Quick Access Toolbar - QAT save Selection and Navigation Sort

Recent Posts

  • 3 Ways To Convert Text To Numbers In Excel
  • 5 Quick Data Set Up Excel Shortcuts
  • Excel Shortcut Bible: Comprehensive Excel Shortcut Book
  • 7 Easy Excel Speed Tips
  • Basic Excel Macros: Part 3 Of 3, Personal.xlsb & Adding A Macro To Your Quick Access Toolbar

© 2016 Faster At Excel