Menu
Aug 14, 2017 - These shortcuts help you insert or delete a row, column or cell. If you want a shortcut to delete a cell in Excel, select one cell and press “Ctrl.
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:
(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’).
![Command For Delete On Mac Excel Command For Delete On Mac Excel](/uploads/1/2/5/7/125793866/551224607.gif)
(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!
BY STANLEY ZAROWINQ. I know there are loads of Excel shortcuts that allow me to avoid using the mouse. Maybe you can help me find a shortcut for deleting individual cells and for highlighting a column or row.
A. You’re in luck. There’s help for both. To delete a cell, put your cursor in the cell and press Ctrl+– (that’s Control and the minus key in the numeric keypad). It’ll instantly bring up the delete cell menu.
To highlight a column without the mouse, move the cursor anywhere in the column and press Ctrl+Space Bar and the entire column automatically will be selected. To highlight a whole row, put the cursor anywhere in the row and press Shift+Space Bar.
Do you have a technology question for this column? Send it to Senior Editor Stanley Zarowin via e-mail at [email protected] or regular mail at the Journal of Accountancy, Harborside Financial Center, 201 Plaza Three, Jersey City, NJ 07311-3881. We regret that we cannot answer letters individually. If a question asked by a reader is deemed to have sufficiently broad interest, we will answer it in a forthcoming Technology Q&A column. —The editors |