Clear Contents in Excel (Shortcut)

Sometimes you may have a need to start over by clearing the content of the cells in Excel.

In this tutorial, I will give you the keyboard shortcut to clear contents in Excel.

Shortcut to Clear Contents in Excel

Below is the keyboard shortcut to Clear Contents in Excel:

Delete (recommended)


ALT + H + E + C

How to Use the Keyboard Shortcut to Clear Contents in Excel

Below are the steps to use the above keyboard shortcut:

  1. Select the cell or range of cells from which you want to clear the contents
  2. Hit the delete key

That’s it!

As soon as you press the delete key, it would clear the contents of the selected cells

Important Things to Know About the Clear Contents Shortcut in Excel

  • Using the above keyboard shortcut to clear the contents of the cell would only remove the content within the cell (including any text or formula that is there in the cell). However, this is not going to remove any formatting that is applied to the cell (such as fill color, borders, conditional formatting, etc)
  • If you want to clear the content of the cell and then type something else in that, you can also use the backspace key. To do this, first, select the cell from which you want to clear the content, and then hit the backspace key. This would remove the content from the cell and bring the cursor into the cell so that you can enter the content that you want in the cell

Alternate Ways to Clear Contents in Excel

An alternate way to quickly clear content in Excel is by selecting the cells from which you want to remove the content, right click on the selection, and then clicking on the ‘Clear Contents’ option

Clear Contents option in right click

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