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)
or
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:
- Select the cell or range of cells from which you want to clear the contents
- 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
Other Excel shortcuts you may also like:
- Excel Keyboard Shortcuts
- Edit Cell in Excel
- Merge or Unmerge Cells in Excel
- Apply-Remove Filter In Excel
- Cut Paste in Excel
- Insert Cell in Excel
- Subscript in Excel
- Superscript in Excel
Other Excel Tutorials You May Also Like:
