Delete Cell in Excel (Shortcut)

There are multiple ways to delete a cell or range of cells in Excel, but a keyboard shortcut is the fastest way to do it.

In this tutorial, I will give you the shortcut to delete cell(s) in Excel

Shortcut to Delete Cells in Excel

Below is the shortcut to delete cells in Excel:

Control + Minus key

How to Use the Keyboard Shortcut to Delete Cell in Excel

Below are the steps to use the above keyboard shortcut:

  1. Select the cell or range of cells that you want to delete
  2. Use the above keyboard shortcut Control – (hold the Control key and then press the minus key)
  3. In the Delete dialog box that opens up, select from the options
    • Shift cells left
    • Shift cells up
delete dialog box
  1. Click OK or hit the Enter key

The above steps would delete the selected cells and shift the cells left or up based on the selection you made in step 3.

Important Things to Know About Delete Cell in Excel:

  • You can use the above shortcut with one cell, a range of cells, and even a non-contiguous range of cells.
  • The same shortcut can also be used to delete the entire row or entire column of the selected cells. For this, you need to make the appropriate selection in the Delete dialog box.

Alternate Ways to Delete Cell in Excel:

If you’re not a fan of using keyboard shortcuts, you can also use the below steps to delete cells in Excel:

  1. Select the cells that you want to delete
  2. Right-click on the selection and then click on the Delete option
click on the delete option
  1. In the Delete dialog box, select one of the two options (Shift cells left or Shift cells up) and then click on OK
delete dialog box

Other Excel shortcuts you may also like:

Other Excel Tutorials You May Also Like:

I am a huge fan of Microsoft Excel and love sharing my knowledge through articles and tutorials. I work as a business analyst and use Microsoft Excel extensively in my daily tasks. My aim is to help you unleash the full potential of Excel and become a data-slaying wizard yourself.

Leave a Comment